Tag: displayName

Comparing 2 CSV files with compare-object to get outdated software

Post author By Full Stack
Post date December 11, 2020
No Comments on Comparing 2 CSV files with compare-object to get outdated software

I am writing a script to compare 2 csv files to get the outdated software’s and put them into another csv file. I have a problem when I try to get the outdated softwares, it just shows all the softwares installed again. This is my script. $CurrentList = Import-csv C:\Users\Administrator\CSVReports\InstalledSoftware.csv | select ComputerName, DisplayName, DisplayVersion, […]

Tags displayName, DisplayVersion, I am writing a script to compare 2 csv files to get the outdated software's and put them into another csv file. I have a problem when I try t, it just shows all the softwares installed again. This is my script. $CurrentList = Import-csv C:\Users\Administrator\CSVReports\InstalledSof, LLC ApprovedList.csv DisplayName DisplayVersion Publisher Google Chrome 87.0.4280.88 Google LLC VmWare Tools 10.3.5.104, LLC Only chrome should be in the OutDatedSoftware csv as only the chrome version is different but I get all the softwares. I also want to kn, LLC Win2012R2 Google Chrome 86.0.4280.88 Google LLC Win2012R2 VmWare Tools 10.3.5.10430147 VMWare, LLC Win2016 Google Chrome 86.0.4280.88 Google LLC Win2016 VmWare Tools 10.3.5.10430147 VMWare, Publisher -PassThru | Where Sideindicator -eq '<=' $Outdated = $Outdated | Foreach { $Item = $_ $ApprovedVersion = $ApprovedList | Where {$_, Publisher $ApprovedList = $ApprovedList | select ComputerName, Publisher $ApprovedList = Import-csv C:\Users\Administrator\ApprovedSoftware\ApprovedSoftwareList.csv | select DisplayName, Publisher $Outdated = Compare-Object -ReferenceObject $CurrentList -DifferenceObject $ApprovedList -Property DisplayName

Database Development

SQL Server Indexed View and TOP

Post author By Jessica Alba
Post date December 8, 2020
No Comments on SQL Server Indexed View and TOP

I’m struggling to persuade a query plan to behave as I think it should. The addition of a TOP clause when querying an indexed view is causing a sub-optimal plan, and I’m hoping for some help in sorting it. Environment SQL Server 2019 StackOverflow2013 database (50GB version), Compat Mode 150 (problem is not specific to […]

Tags [A].[DisplayName] FROM [dbo].[Users] AS [U] OUTER APPLY ( SELECT * FROM [dbo]., [A].[DisplayName] FROM [dbo].[Users] AS [U] OUTER APPLY ( SELECT TOP 1 * FROM, [A].[Reputation], [Reputation] FROM [dbo].[Users] WHERE [Reputation] > 10000 Next, and I still get a seek with only 63 reads against my index (this is obviously a contrived example, and I'm hoping for some help in sorting it. Environment SQL Server 2019 StackOverflow2013 database (50GB version), but doing so around 2.5 million times. It is also scanning the whole of the Users table. It no longer seeks on the view's index. Obviously t, but helps illustrate the problem that I'll come to): SELECT [U].[Id], but I can't understand why! I've think it's probably to do with the way the underlying tables are sorted, but I'm not sure. Incidentally, Compat Mode 150 (problem is not specific to this version) The setup: Firstly, displayName, I can see my nonclustered index is being used: SELECT * FROM [dbo].[vwHighReputation] WHERE [DisplayName] LIKE 'J%' Plan: (https://ww, I'm struggling to persuade a query plan to behave as I think it should. The addition of a TOP clause when querying an indexed view is causing, I've created a couple of indexes on the view: CREATE UNIQUE CLUSTERED INDEX IX_Users_Id ON [dbo].[vwHighReputation]([Id]) GO CREATE NONCLUST, I've created a view to return everyone with a high reputation: CREATE VIEW vwHighReputation WITH SCHEMABINDING AS SELECT [Id], if I add a TOP 1 to my OUTER APPLY: SELECT [U].[Id], re-writing it as a simple SUB QUERY rather than CROSS APPLY yeilds the same outcome. Any help or advice would be great!, since I'll be searching by display name, very bad.... Plan: https://www.brentozar.com/pastetheplan/?id=HyOS6yaiw My logical read count against that view is now almost 5 million. I

Mastering Development

Getting undefined for firestore document after .get()

Post author By Full Stack
Post date November 26, 2020
No Comments on Getting undefined for firestore document after .get()

I really don’t know why I’m getting this annoying undefined after using .get() method, (This reafctoring this function as contribution for an open source but there 2 line of code was there for more than a moth and worked fine, I don’t know why its not working for me) This is my function: export async […]

Tags (This reafctoring this function as contribution for an open source but there 2 line of code was there for more than a moth and worked fine, }; return userRef.set(updatedUserObject).then(() => updatedUserObject); } }, createdAt: firebase.firestore.FieldValue.serverTimestamp(), displayName, exists: true }; } else { const { uid, first_name: initialFirst, I don't know why its not working for me) This is my function: export async function saveUserInFirestore(userData) { const userRef = await, I really don't know why I'm getting this annoying undefined after using .get() method, initialFirst, initialLast, last_name: initialLast, pictureUrl, pictureUrl } = userData; const updatedUserObject = { uid

Mastering Development

Django + React Able to create new user in database, but token-auth returns 400 bad request

Post author By Full Stack
Post date November 19, 2020
No Comments on Django + React Able to create new user in database, but token-auth returns 400 bad request

So I have an app that I’m writing. It’s working, for the most part, so far. I only currently have a login and signup setup, with a ‘homepage’ that just has a logout button and some text on it so I can test. When I do signup, it posts the user to the database, but […]

Tags 'dnt', 'GET, 'grade_taught', 'http://localhost:3000/' ] }, 'JWT_VERIFY_EXPIRATION': False, 'PUT', 'room_number' ] class InstructorSerializerWithToken(serializers.ModelSerializer): token = serializers.SerializerMethodField, 'room_number' ] Related Views: class InstructorList(APIView): permission_classes = (permissions.AllowAny, 'x-csrftoken', 'X-Requested-With'], "*" ] JWT Auth settings: JWT_AUTH = { 'JWT_RESPONSE_PAYLOAD_HANDLER': 'diceapp.utils.my_jwt_response_handler', "Accept-Encoding", ) CORS_ALLOW_METHODS = [ 'DELETE', ) def post(self, ] CORS_ALLOW_HEADERS = [ 'accept', { method: 'POST', }, } Edit: Adding the request that causes the bad return. const handleLogin = (username, //['Authorization'], //['Content-Type', $username, Accept, blank=True, body: JSON.stringify({ username: username, but then I get this: Bad Request Image Here is my Instructor Model: class Instructor(AbstractUser): displayname = models.CharField(max, data.token); props.updateToken(data.token) }) .catch(error => console.log(error)) history.pus, displayName, email_address, for the most part, headers: { "Content-Type": "application/json" }, it posts the user to the database, None) instance = self.Meta.model(**validated_data) if password is not None: instance.set_password(password), null=True) email_address = models.EmailField(blank=True, null=True) grade_taught = models.IntegerField(default = 0) room_number = models.IntegerField(default = 0) Serializer(Instructor and, obj): jwt_payload_handler = api_settings.JWT_PAYLOAD_HANDLER jwt_encode_handler = api_settings.JWT_ENCODE_HANDLER pa, OPTIONS, Origin, PASSWORD, password: password }) }) .then(res => res.json()) .then(data => { localStorage.setItem('token, password) => { const url = 'http://127.0.0.1:8000/token-auth/' fetch(url, PATCH, post, request): serializer = serializers.InstructorSerializerWithToken(data = request.data) if serializer.is_valid():, so far. I only currently have a login and signup setup, So I have an app that I'm writing. It's working, status = status.HTTP_201_CREATED) return Response(serializer.errors, status = status.HTTP_400_BAD_REQUEST) class InstructorViewSet(viewsets.ModelViewSet): queryset = models.Instructor.objects.all() ser, User-Agent, validated_data): password = validated_data.pop('password', with a 'homepage' that just has a logout button and some text on it so I can test. When I do signup

Mastering Development

How to display sender’s and reciever’s photo in imessage app?

Post author By Full Stack
Post date November 13, 2020
No Comments on How to display sender’s and reciever’s photo in imessage app?

In iMessage app I’ve created profile photo for sender and reciever. Only registered users with Google authentication are able to message. On messaging both the sender’s and reciever’s profile photo are displayed. But, the photo isn’t placed as expected besides message bubble, probably minor CSS issue. Following are the required files Message.js import React, { […]

Tags .bubble:after { border-radius: 20px / 5px; content: ''; display: block; position: absolute; } .bubble:before { border: 10px solid, "white", [0.65, { forwardRef } from "react"; import "./Message.css"; import { Avatar } from "@material-ui/core"; import { selectUser } from "../redux/userRed, #3cabfa 100%); background-image: -moz-linear-gradient(bottom, #3cabfa 100%); background-image: -ms-linear-gradient(bottom, #3cabfa 100%); background-image: -o-linear-gradient(bottom, #3cabfa 100%); background-image: linear-gradient(bottom, #3cabfa 100%); color: white; } .blue:after { border-bottom-color: #3cabfa; } This is the output Expected Any appropriate changes h, #3cabfa)); background-image: -webkit-linear-gradient(bottom, #bcbcc0 100%); -webkit-border-radius: 20px; -moz-border-radius: 20px; border-radius: 20px; -webkit-box-shadow: inset 0 8px 5px rgba(, #bcbcc0 100%); background-image: -moz-linear-gradient(bottom, #bcbcc0 100%); background-image: -ms-linear-gradient(bottom, #bcbcc0 100%); background-image: -o-linear-gradient(bottom, #bcbcc0 100%); background-image: linear-gradient(bottom, #bcbcc0)); background-image: -webkit-linear-gradient(bottom, #bee2ff), 0, 0 1px 2px rgba(0, 0.2); -moz-box-shadow: inset 0 8px 5px rgba(255, 0.2); box-shadow: inset 0 8px 5px rgba(255, 0.2); margin-bottom: 20px; padding: 6px 20px; color: #000; text-shadow: 0 1px 1px rgba(255, 0.5); bottom: 0px; left: -7px; z-index: -2; } .bubble:after { border: 8px solid transparent; border-bottom-color: #bcbcc0; botto, 0.8); } .bubble span.avatar { position: absolute; } .bubble>small { color: gray; position: absolute; font-size: 8px; bottom: -0.5, 255, color-stop(0.15, color-stop(1, contents: { timestamp, displayName, EMAIL, In iMessage app I've created profile photo for sender and reciever. Only registered users with Google authentication are able to message. On, left bottom, left top, message, photo: [], probably minor CSS issue. Following are the required files Message.js import React, ref ) => { const user = useSelector(selectUser); return ( <div ref={ref} className={`bubble $, the photo isn't placed as expected besides message bubble, uid, white 15%

Mastering Development

Unable to execute Matlab code both in Jupyter and online compiler

Post author By Full Stack
Post date November 10, 2020
No Comments on Unable to execute Matlab code both in Jupyter and online compiler

I need to see the code output of the following matlab code. %Defining the arrays i=1200; XbFe=zeros(1,i); XbCr=zeros(1,i); XbO2=zeros(1,i); XbFeO=zeros(1,i); XbCr2O3=zeros(1,i); CbFe=zeros(1,i); CbCr=zeros(1,i); CbO2=zeros(1,i); CbFeO=zeros(1,i); CbCr2O3=zeros(1,i); keq_FeO=zeros(1,i); keq_Cr2O3=zeros(1,i); val=zeros(1,i); XiFe=zeros(1,i); XiCr=zeros(1,i); CiFe=zeros(1,i); CiCr=zeros(1,i); JFe=zeros(1,i); JCr=zeros(1,i); MolesTransFe=zeros(1,i); MolesTransCr=zeros(1,i); MolesTransfFeO=zeros(1,i); MolesTransfCr2O3=zeros(1,i); MolesTransO2=zeros(1,i); MFe=zeros(1,i); MCr=zeros(1,i); MO2InMetal=zeros(1,i); Moxy=zeros(1,i); MCr2O3=zeros(1,i); MFeO=zeros(1,i); MassOfFe=zeros(1,i); MassOfCr=zeros(1,i); MassofO2=zeros(1,i); MassOfFeO=zeros(1,i); MassOfCr2O3=zeros(1,i); TotalMolesInMetal=zeros(1,i); TotalMolesInSlag=zeros(1,i); TotalMassOfMetal=zeros(1,i); TotalMassOfSlag=zeros(1,i); […]

Tags 'PerCr2O3InMetal'}); figure(2) plot(TotalMassOfMetal, 'PerCr2O3InSlag');hold off; legend({'PerO2InMetal', 'PerCrInMetal', 'PerCrInMetal');plot(PerCr2O3InSlag, 'PerFeInMetal', 'PerFeInMetal');plot(PerCrInMetal, 'PerFeOInMetal', 'PerFeOInSlag');plot(PerFeInMetal, 'PerO2InMetal');hold on;plot(PerFeOInSlag, 'TotalMassOfMetal');hold on;plot(TotalMassOfSlag, 'TotalMassOfSlag');hold off; legend({'TotalMassofMetal', 'TotalMassofSlag'}); I installed the matlab-kernel in my conda environment and opened a Jupyter notebook to run the code. Running a conda l, displayName, I need to see the code output of the following matlab code. fining the arrays i=1200; XbFe=zeros(1, i); CbCr=zeros(1, i); CbCr2O3=zeros(1, i); CbFe=zeros(1, i); CbFeO=zeros(1, i); CbO2=zeros(1, i); CiCr=zeros(1, i); CiFe=zeros(1, i); JCr=zeros(1, i); JFe=zeros(1, i); keq_Cr2O3=zeros(1, i); keq_FeO=zeros(1, i); MassOfCr=zeros(1, i); MassOfCr2O3=zeros(1, i); MassOfFe=zeros(1, i); MassOfFeO=zeros(1, i); MassofO2=zeros(1, i); MCr=zeros(1, i); MCr2O3=zeros(1, i); MFe=zeros(1, i); MFeO=zeros(1, i); MO2InMetal=zeros(1, i); MolarVM=zeros(1, i); MolarVS=zeros(1, i); MolesTransCr=zeros(1, i); MolesTransfCr2O3=zeros(1, i); MolesTransFe=zeros(1, i); MolesTransfFeO=zeros(1, i); MolesTransO2=zeros(1, i); Moxy=zeros(1, i); PerCr2O3InSlag=zeros(1, i); PerCrInMetal=zeros(1, i); PerFeInMetal=zeros(1, i); PerFeOInSlag=zeros(1, i); PerO2InMetal=zeros(1, i); time(1)=0; %User Input TotalMassOfMetal(1) = input("Input Total Mass of Metal:" ); TotalMassOfSlag(1) = input("Input Total Mass of Slag, i); time=zeros(1, i); TotalMassOfMetal=zeros(1, i); TotalMassOfSlag=zeros(1, i); TotalMolesInMetal=zeros(1, i); TotalMolesInSlag=zeros(1, i); val=zeros(1, i); VM=zeros(1, i); VS=zeros(1, i); XbCr=zeros(1, i); XbCr2O3=zeros(1, i); XbFeO=zeros(1, i); XbO2=zeros(1, i); XiCr=zeros(1, i); XiFe=zeros(1, there is not output. Restarting the kernel also yields no result. In fact the cell in Jupyter reads as IN[*]. So I switched to see if I can

Mastering Development

ignore the following properties in swift Codable?

Post author By Full Stack
Post date October 17, 2020
No Comments on ignore the following properties in swift Codable?

I have this Account struct. I want to ignore the following properties environments and Id in encoding to JSON object when I send "POST" endpoint and use them return success decoding to swift object struct Account: Codable { let accountID, displayName, managedByID, id: String let environments: [Environment] let contacts: [Contact] enum CodingKeys: String, CodingKey { […]

Tags CodingKey { case accountID case displayName case managedID case id case environments case con, displayName, I have this Account struct. I want to ignore the following properties environments and Id in encoding to JSON object when I send "POST" endpo, id: String let environments: [Environment] let contacts: [Contact] enum CodingKeys: String, managedByID

Mastering Development System & Network

Why does this powershell command using Get-Service not continue if it encounters an error?

Post author By Server Questions
Post date September 21, 2020
No Comments on Why does this powershell command using Get-Service not continue if it encounters an error?

I’ve been tasked with auditing Windows servers to see what services and programs are installed. I though PowerShell would be ideal for this, though I am new to PowerShell scripting. I have a list of servers in a txt file and have been using the following commands. Get-CimInstance -ComputerName (Get-Content .\servers.txt) -ClassName win32_product | Select-Object […]

Tags `status`, 'InstallDate', but why does the statement not continue on error as expected? If I remove the bad server from the list, displayName, Get-Services runs fine. I'd rather get an error in the script and deal with that separately. Update to include Powershell output Get-Servic, I've been tasked with auditing Windows servers to see what services and programs are installed. I though PowerShell would be ideal for this, IdentifyingNumber | Export-CSV -Path .\programs.csv Get-Service -ComputerName (Get-Content .\servers.txt) -ErrorAction Continue | Select-Obj, InvalidOperationException + FullyQualifiedErrorId : System.InvalidOperationException, Microsoft.PowerShell.Commands.GetServiceCommand, Name, packageName, StartType | Export-CSV .\services.csv The .\servers.txt is a simple text file with the server FQDNs. If the server is inaccessible or not f, the first statement prints an error message and continues. As I understand the ErrorAction by default is to continue. However, the second statement fails and stops executing. I expect there will be errors and I could deal with them on a case by case, though I am new to PowerShell scripting. I have a list of servers in a txt file and have been using the following commands. Get-CimInstance

Mastering Development

Looping and adding extra properties to a Object

Post author By Full Stack
Post date September 18, 2020
No Comments on Looping and adding extra properties to a Object

I’m running a simple script to check if several specific services are running on an array of computers. It works fine, except the each ‘row’ appears’ for every iteration of the loop. In this case 3 times. How do I edit/add to a property of an existing object? I.e. I want to add extra properties […]

Tags 'Cb Defense' $objarray = @() $obj = @() $ServiceArray = get-service -ComputerName $ComputerName -DisplayName $ServiceList | select-object, 'dc02' $ServiceList ='Qualys Cloud Agent', 'ds01', 'SplunkForwarder Service', displayName, except the each 'row' appears' for every iteration of the loop. In this case 3 times. How do I edit/add to a property of an existing object?, I'm running a simple script to check if several specific services are running on an array of computers. It works fine, Name, Status Foreach ($Computer in $ComputerName){ $obj = New-Object PSObject $obj | Add-Member -MemberType NoteProperty -Name "ComputerN

Mastering Development

Getting “TypeError: string indices must be integers” when trying to get the user id from firebase (pyrebase)

Post author By Full Stack
Post date August 21, 2020
No Comments on Getting “TypeError: string indices must be integers” when trying to get the user id from firebase (pyrebase)

In my code the user logs in with the email and password method. The user variable is user = str(auth.sign_in_with_email_and_password(email, password)) when trying to get the idToken from this with uidToken = user[‘idToken’] i get the error in the title If i print out user it gives me {‘kind’: ‘identitytoolkit#VerifyPasswordResponse’, ‘localId’: ‘cSZHkRIzGPWfuMmaZ93STFVvdr43′, ’email’: ‘1@1.com’, ‘displayName’: […]

Tags 'email': '1@1.com', 'expiresIn': '3600'} i tried import json user = json.loads(user) but got an error edit: i removed the str() from user as i believe this is, 'idToken': 'eyJhbGciOiJSUzI1NiIsImtpZCI6IjEyODA5ZGQyMzlkMjRiZDM3OWMwYWQxOTFmOGIwZWRjZGI5ZDM5MTQiLCJ0eXAiOiJKV1QifQ.eyJpc3MiOiJodHRwczovL3NlY3, 'localId': 'cSZHkRIzGPWfuMmaZ93STFVvdr43', 'refreshToken': 'AE0u-Nf0xpXPRjHUrIwCFOeSqVG709oIP5Yfjab7MRy8Eckk4Nx7jUGJGRHlMphFdVlKPwwK6_mE9ynAp-CnlVwM58dNHnAiD_4nzL7VgK-XX4vTBVbnAhNK-3r1, 'registered': True, displayName, In my code the user logs in with the email and password method. The user variable is user = str(auth.sign_in_with_email_and_password(email, password)) when trying to get the idToken from this with uidToken = user['idToken'] i get the error in the title If i print out user it giv