Webcast: Power user tips in PDQ Deploy & Inventory - Transcript

company JJB
JJ Bateman|April 22, 2021
Power User Tips in PDQ Deploy and Inventory
Power User Tips in PDQ Deploy and Inventory
    No Data

    SPEAKERS Lex, JJ, Jake, Jordan, Kelly

    Lex  00:01 --- To me,

    Jake  00:02 --- script just decided to finish on its own. 

    Lex  00:04 --- Shouldn't I plug that back in Jordan? I was doing well. Thank you. Hey, welcome to the most professional webcast on here. Today, you know, we're gonna take you through some, you know, pro tips, things that should, you know, hopefully, maybe spark some ideas and help you guys along the way. If not, hopefully it's not a big letdown. Let's jump in

    Jordan  00:28 --- real quick people in chat saying that there's an echo for them. Is that still going on?

    Lex  00:33 --- I guess I can do some Ron Burgundy quotes.

    Jordan  00:36 --- Oh, it's gone. Okay. It's

    Lex  00:37 --- gone. Okay. Save me because I came up blank with nothing for Ron Bergen either. Okay. First thing, let's start out with, you know, again, I love talking with customers and that everyone's like, do you guys have an approved application list or report. So we decided we can show you how we thought of building one and then we'll, we'll go from there. So what, Jurgen and I did the other day, and we tried this this morning, and it worked almost well. And then we figured out, it was a good way to explain why it worked the way it did. But I'm going to build a report, just a basic report. And all we're going to do is pull all the application names, and run that report against all computers. And there's the report, tab. Now, honestly, you guys have all seen me tight, this is not a new thing. So you don't want to see me typing this in. So we decided to do this a little easier, make it a bit more automated. So I'm going to save this file as a CSV, we'll just call it apps. And we'll drop it on my desktop. Okay, now the nice thing about this again, okay, we're gonna pop this open, closes. And we don't need to save that. But if I edit this with notepad plus plus, here it is. So the first thing you want to do is get rid of that, that hit or that application. And now we're going to use regular expressions to build this comparison of approved apps versus non approved apps. And a couple things you know, with regular expressions or certain characters you can't use, we tried it earlier, it didn't work. So you can't use pluses you can't use Jordan jump in with me here. 

    Jordan  02:18 --- I can't use numbers I assumed that you can't use numbers, the dots in the version version numbers and the version numbers. We had to do a lot of cleanup before this work. So just be ready to just use this as reference and

    Lex  02:29 ---  be prepared to watch me do this a couple of times. Okay, so what we did find that works really really well and easy as this right? So sevens if you notice I've got a 64 bit and 32 bit version right there. All I need to know is seven zips. Okay, so I'm going to get rid of all of the, you know, pretty much everything except for just seven zip, right? I'm okay with Adobe products. So I just need Adobe once. Okay. autohotkey is not approved in my world. So I'm going to get rid of this off this list. Okay, again, similar things here blue fish, I don't want browser cannon stuff, not necessarily, I think should be approved. So what I'm doing is I'm getting rid of stuff that I think should not be approved. Okay. Now, the other thing is, you can do that again, I need to get rid of you know, the version numbers seem to you know, cuz we want to make comparisons against things like Google Chrome or, for example, you know, those kinds of things. So I'm just gonna do a kind of a massive get rid of here so I don't need these because I think those are not appropriate but Evernote's Okay. Hey, Filezilla is okay. So I'm just keeping you know, approved possible vendors here. So Google Drive and Cromer, okay, so I'm just gonna keep Google. Alright. So, again, go on through here. If you do this, again, it's going to make this pretty easy. I'm going to go nuke a bunch of stuff down here to Microsoft to give you guys the idea because otherwise I'm gonna be here all day approving or not approving stuff. So get rid of that. Now you do Firefox Thunderbird, okay, with those Jordans,

    Jordan  04:02 --- they work for me.

    Lex  04:03 --- Alright, we'll just get rid of them. Well, now I'm gonna keep in video because they'll show up everywhere.

    Jordan  04:07 --- I'm just wondering, did you not approve of autohotkey because you hate the highlighter.

    Lex  04:12 --- Is it that obvious? Isn't that obvious. So I'm gonna keep one in video. And then we'll just get rid of the rest of this, for example purposes, okay,

    Jordan  04:19 --- you just bought PowerShell real nice, real nice.

    Lex  04:22 --- Hey, nobody is not approved in my world that's not approved. Now, the thing about this is to turn this into a regular expression. We're gonna go in here and we're going to do a Ctrl F. And we'll do a replace now, to get rid of air, a carriage return for the new line and replace it with a pipe. So we've got this and this and this and this or this will excuse me, it's not and it's or this or this or this. Hey, you'll notice right here I've got the bracket. It's a backslash n backslash, our closing bracket plus and we're replacing that carriage return with a pipe. You do need to go down here and whack regular expressions and then replace So and you'll notice now I have a really nice string.

    Jordan  05:04 --- Hey, do you want spaces? Yeah, the

    Lex  05:07 --- Another thing to look for. Thank you for removing these spaces. Okay? And then we're going to copy this. And we're going to build a variable, inventory options, variables, and we're gonna call it approved apps. I already did that earlier. And then what I'm going to do is I'm just going to paste that in there. Okay. Now, if this works out, and I say if because sometimes, you know, I might have missed something, and there was a lot of stuff. I 

    JJ  05:35 --- should probably make sure that PDQ inventory is on that approved list.

    Lex  05:39 --- Maybe, maybe we're, I'm going to show you how to add things. We're going to go through this, guess what, we're gonna build a new report. It's approved. Okay. Well, the nice thing is, this is not a, you know, you can change this. So we're looking at the, in this case, I'm just going to go look at computer names application name, okay. And our filters, we're going to add the application name. And we're going to use does not match expression. And we're going to use that super cool custom variable i just did. And we'll call this bad, bad. Apps. Right. And we'll run it. There we go. Okay, so here, first of all, you notice I get some VMware, let's just do this in order. So I can see VLC v mix. So VMware that's approved, let me show you how quickly you can go in and change that. Right. So I'm gonna save this, we'll just minimize it. We'll go back in here to our variables. Back to the end of this guy. pipe. vmware. Right.

    Jordan  06:45 --- Did you do a pipe in at PDQ quick, do you know, I

    Lex  06:47 --- think that's probably PDQ is also the backslash. That's MC. This is why this took so much time this morning. If you don't do it, right, it really Jacks up your filter. And then we'll just go run a report one more time. And now VMware Tools is going to notepad plus PDQ is approved. So again, this is going to take a little bit of work. But again, that initial building that report and doing that, you know, just going for, you know, beginnings of names and things that you need, is going to help make this a lot easier,

    Jordan  07:20 --- it's going to take a lot of work at once is super useful. One thing that you did that you didn't throw out right away is you clicked out of the variable once you added to it. Oh, that's right, because it won't update properly. Without this, you got to click outside there.

    Lex  07:32 --- So if I wanted to go out and notepad plus plus, show it not working, so we'll go in here. And maybe it's not not working, we'll just show me not exiting it. So and paid Notepad, okay, I'm not exiting it now go rerun the run, that's not the report, the rerun that report, if I don't exit it, notepad plus, plus is still there. Again, back to variables. Let me exit it. So it updates. And then this time, there you got notepad plus plus is gone. So just make sure you, you know, update your variable, exit it, and then it does update. Jordan, any other things you might want to discuss in regards to this, this does take a little bit of work. But again, if you spent more time going through that list than I did, your first go around is going to be so much easier.

    Jordan  08:19 --- It's a little bit of frustration for friends to know when anyone in your environment is installing things that they shouldn't be.

    Lex  08:26 --- And again, so beta made a basic report application names, I exported that to a CSV, opened it Notepad, again, you know, we use the Find and Replace. So that is a good way to get started on building an improved app or a bad apps report, depending, you know, approving your apps and then having your bad apps report. So with that, should we jump into a question?

    Kelly  08:52 --- Hey, guys, could you give us some tips on extending the collection library or creating our own? We need to be more specific with Microsoft Office 365 Pro Plus apps for enterprise build numbers, etc. Thanks, ma.

    Lex  09:08 --- Excellent. That's a great question. You know, we kind of went over in another webcast. But Jordan, thank you for sending that early. Because we have Jordan, where is that? PowerShell located my friend. It's in Autobot. Assembly Autobot assembly and it is called auto collection. ps1. Let me open that. We'll just edit it. So you can see what's going on. Jordan, you want to kind of explain what's happening here? Yes.

    Jordan  09:34 --- Okay, go through and make it professional. And like the first time we showcased it, not so much nicer me. So yeah, so this one, basically, you're gonna run the script, you have to provide four bits of information. It's the name of the variable for the application that goes into the collection, the name of the variable name for the version, and then you have to supply the application and the version. This variable is not really clear. If you look at the GitHub There is the readme that I go into a bit more detail on what each one does. And the last one version and title is for something like seven zip where they're monsters and adds it to the end, it makes it a little bit more shaky on the collection. If you add that attribute, you don't have to put anything after we'll make that a true flag and it changes it a little bit on how it imports.

    Lex  10:18 --- Okay. The other part of this is it does use what is that XML,

    Jordan  10:25 --- I name your application, okay?

    Lex  10:27 --- Name your application XML. So it's going to use that to actually go build this, let me just run this for you so you can see what it's going to do. So open up our PowerShell window. Get ready for me to type really fast. There we go. Did you Did I did it? Did you see that? It was two up arrows. And so we're calling auto collection. ps1, or variable name in this case is six zip app.

    Jordan  10:52 --- Yep, that's not actually what's going into the variable that's just to the name of the

    Lex  10:56 --- application name in this case is six zip. We just needed something guys, because we already have a seven zip. Variable version name is zip. Thanks. That's how you did the six zip madvr. Wow, it's worked out great. For me, this is just a bunch of comedy. Thank you. Alright, so in this case, when I run this by hitting the Enter key at this point, right? It's going to create a six zip. I'm not going to translate it again. that exists in Autobot. Assembly also, right? So out about assembly, six, zip XML. So now all I have to do to get that is important. Right click Import six zip. If you know, man, I hate you. Joyce has been great. This is. So they're there their

    Jordan  11:45 --- new collection view and expanded it. Yeah, let's show these are

    Lex  11:49 --- all the parameters there. And the nice thing is it also created some new custom variables.

    Jordan  11:56 --- See what update there in your collection update.

    Lex  11:58 --- There you go. So as soon as that's, you know, version 25, you just have to update it there and everything gets updated down the path.

    Jordan  12:05 --- And that script is just in our GitHub for an under bonus content.

    Lex  12:10 --- There you go. I would highly love this because it has made my life significantly easier. So good question. Thank you. And hopefully that will hook you up. I just want to point this out. If you do use this to build your collections, it becomes really easy to build an old apps report. And since we're here, I'm just going to do that. I'm going to build a new report, a basic report, we'll just call this “old apps”. Okay, and we're going to look for computers where the member AD group has a name obviously in our filter is going to be the member AD group or not AD group, holy cow member of collection group name contains old sorry, let me go make sure I grabbed the right one cuz never eight nope to collection group guys, and be some hilarious collection that report though. There you go. Thank you, I am gonna run this against all machines. And this guy, I'm going to group by machines. So you can see which of my machines is the worst 10 on Charles McGill. He's got chrome old edge old Google Drive old, old, old, old, old old. So there you go. schedule that was thrown out. And now every couple of weeks, and you see how well you're keeping your stuff up to date. So there you go. There's another one for you. All right, next on the list, custom fields. In this case, we're going to do it like a primary email address for a machine. Now a lot of people ask, How do I get what I want to see up here on this, you know, the all computers you know, I guess, basic screen up here. And to do that, you build a custom field because custom fields get put in the computer table. And then anything in the computer table you can put here. So options, custom fields, we're going to name this new field, we'll call it, it's gonna be a text field, and it'll be primary email. And I'm doing an old school with no spaces. For I never notice that we don't call it a Boolean. We call it true. False. Interesting. True. False. Yeah. All right. So now because I've done that, I can go in here, right click, and I can go to.

    Jordan  14:16 --- So real quick for the Import Wizard. I think in the CSV, we just named it as email. I'm not sure if the name disconnect will work without having to

    Lex  14:24 --- tie those together. Oh, I see how it is. Let's go fix that before I try and do something that's not gonna work. credentials.

    Jordan  14:31 --- I think you can go in and specify time together manually. But if it's just an email, it should just work. Let's do email.

    Lex  14:39 --- Let's do email. Just email. All right, let's delete it and build a new email. So this is how you do it wrong. Now this is how you do it, right? text, thank you. Email. Alright, so I guess once you name it, can't change it, get to delete it and re add it. Then back here. We're going to go and find Email, there it is we'll add it, and it will tag it fixed point and there is our email. Right? Put it right. Actually, I didn't want it there. Wow, that is impressive that I moved it that far. move this down a little bit. Alright. So there's our email, which is blank. Now, luckily, Jordan has already built an email, CSV, which has got computer names and all the emails that approach or go with those and email is accurate. Yes, very accurate emails. So you can from the custom fields here, go and run the Import Wizard. In this case, I'm going to grab that CSV off the desktop, email. Okay. And then you're gonna want to map that obviously computer name, computer name, email, email. Okay. I hit next and import this, but you can also do it from the command line.

    Jordan  15:57 --- Right? Yeah. And I think we have that already added to the bump. I'm not sure if that has to run as administrator or not, I assume it will since the

    Lex  16:06 --- Well, let's just go and bring it up. Or should I go in? We'll do it from here. Alright, so we'll go straight as administrator. All right, well, let's go do this. PowerShell will go and run this as administrator. Okay. And then we'll go to the desktop. Actually, you don't want to go show him what this looks like. So let me open the is here. poser PowerShell. I see myself as an administrator. Anytime, Bueller,

    Jake  16:47 --- sorry about that Zoom.

    Lex  16:47 --- Did you Zoom in there perish

    Jordan  16:50 --- from the chat. It's when key plus x y enter. I actually didn't even know about sroka. That's love. And I will be using that a lot in the future. Thank you, Luke.

    Lex  17:04 --- All right, so we're looking at importing custom fields. So basically, we're gonna be calling PDQ inventory, importing custom fields file names. Is that gonna run? Is that going to import that where it needs to go?

    Jordan  17:20 --- We guess we'll find out. All right, let's

    Lex  17:21 --- do it. 

    JJ  17:23 --- You've got some  UAC prompts screaming at ya.

    Lex  17:28 ---  Alright, let's go take a look. See how we did. Custom Fields might didn't populate right away if you refresh. Okay, let's just go look at custom fields, really quick custom fields. There's the third example. Need more examples? The email. Excellent. And then if I go back here and refresh the screen, right. Should be

    Jordan  17:50 --- clicking on the hit f5 f5.

    Lex  17:53 --- Thank you. We should start seeing our email addresses show up there being where I hope so. Otherwise,

    Jordan  18:03 --- that shouldn't take that long. Bueller. Did you break it?

    Lex  18:06 --- Bueller? Did we break? It wouldn't be surprising today. Last day in the studio. Here it is. Okay. took a minute. But there they are. Tonight. You can see him. So remember, if you want to add fields to this, you know, default front screen here to custom field, you need to populate it. So do we have? Should we ask some questions? Just run questions? Or what do you think?

    Kelly  18:33 --- Hey, guy is within computer details. And within the attribute shares, I can only assume the name column is in reference to what an actual share name is? If so, how do I remove the share? If not, how do I get the actual share name and remove it without their knowledge? Sincerely, Thomas t. Tank Engine.

    Lex  18:55 --- Alright, right. So shares. And in this case, we're showing the admin dollar see dollars IPC dollars. I don't think I've gotten the shares out there to show you

    Jordan  19:04 --- on how to remove I'm not sure.

    Lex  19:07 --- I obviously need to remove that share from the machine itself. And then when you update the scan, it's going to take care of it that way. That's where I would go to take care of a share. Get a share.

    Jordan  19:18 --- Yeah, I mean, is it added to the user profile or the machine profile? I'm not sure if we have anything to highlight which one can you click on those UACs and close those out for me that is going to drive me nuts. Oh, down here. Yeah, really?

    Lex  19:32 --- He's been bugging me this whole time. Oh, check that up. I love that blink in there. Do you know after you name that six zip. So

    Kelly  19:43 --- you deserve to have your OCD messed with Georgia.

    JJ  19:45 --- sysadmin vs. sysadmin.

    Lex  19:47 --- There you go. So I would first look at removing the share from the machine because running out of inventory. Next time you get a scan, it's going to come back so go to the source and get rid of it there.

    Jordan  19:58 --- Yeah, there's going to be PowerShell. I don't have a friend who's gonna be PowerShell. You could write, you can run against machines to disconnect shares that you're not wanting in there. But it's

    Lex  20:06 --- just depends on where it's being. I mean, is it Group Policy Object making? It is, you know,

    Jordan  20:12 --- if it's group policy is going to keep coming back until you remove that. That's a good point. So

    Lex  20:16 --- little research there. But yeah, go to the source read over there. Yeah, another question.

    Jordan  20:21 --- Well, as Ron said, if you're going to bulk manage shares, then groups also have something that will say, only these are accepted shares to block people from creating in the first place. Cool.

    Kelly  20:35 --- Gentlemen, I have an auto report in inventory scheduled every day, but it can go days between actual runs, and he points to look for why. Thanks, Alan. l.

    Lex  20:48 --- So an auto report, and it's supposed to run every day, and then it goes days without running. Hmm. I would take a look at a couple things one. For now, is it writing a file that's got a name or date? You know, or is it just trying to write the same file? And if it is, are you overwriting the one that's there? Because it's a possibility, maybe they don't notice. The other thing, your triggers, your daily triggers? You have an end date, a start and an end date? Because I've run into that with other schedules where it ended at a certain time you expected it, and then it didn't go, but I guess,

    Jordan  21:27 --- if it's every couple of days, if you that might be one where you might want to open a ticket.

    Lex  21:32 --- Yeah, I was gonna say if it's beyond those two things, I mean, just check them. Probably, you know, I just make sure it's not it's override if it is overriding your notice and but open a ticket if it's anything other than that. So yeah, get another question.

    Kelly  21:50 --- Dear Lex and Jordan, we are using Google Drive stream when you log into drive stream, now just Google Drive, it creates a drive G is there a way in inventory to scan to see if the currently logged on user has created that G Drive kinda like the map drives Curtis J?

    Lex  22:09 --- Trying to think would you go after a file share a file a directory is using SMB using,

    Jordan  22:17 --- I guess test for G just the G drive itself and see if it's there. Otherwise, there might be a W my query or a PowerShell scan you can use to to look for mapped drives, or

    Lex  22:27 --- Yeah, okay, so can we see drives directories? I know in Linux, you do. But there's windows c drives directories like in UNC path sort of thing.

    Jordan  22:37 --- You could do a test path with PowerShell will basically say if G it would basically return to true false for the test path for GE only.

    Lex  22:45 --- Okay, so you could run a PowerShell scanner to test for that. Yes. Okay. That's where I would go. So hopefully that helps out that I can write that live. Okay, not that I can write that. I'll let Jordan do it. But yeah, that's where I would go the path I would take. Yeah, let's let's do another one.

    Kelly  23:07 --- Yeah, we've got two or three more. Can we automate scheduled history cleanup when packages updated slash file are replaced? That comes from Marcel L.

    Lex  23:19 --- Yeah, yeah, you can do that's a power show. We've done that before. I think if you look at our automated packages that aren't in our package library, that webcast, we got some PowerShell that actually, you've got to feed it the skid the schedule ID, and it will go clean that schedule up for you. Are you remembering this? Yeah.

    Jordan  23:38 --- So if you go to the bonus content, there's an ultimate package. And then there's a PowerShell script in there. That's update bars. Down at the bottom, there's a section that started line 33 that deleted schedule history. And basically you have to supply the schedule ID and then run that group of commands. And we'll go through and remove every machine from the history

    Lex  23:58 --- to recently put that link in chat if it's not already there. Absolutely. Thanks, man. Good question, Marcel. Alright, you want to ask more questions? Or should I show how to get non admin users?

    Kelly  24:10 --- Let's be non admin users. All right.

    Lex  24:13 --- So picture this. You want to know who's got admin rights on your machine, right? Or he's part of the admin group. So we're going to show you how to build a report to get that. So we'll go to reports. Now, this is how I'm just going to show you how I do reports, guys. It is kind of like the man's quest for fire. It's very basic and builds on itself. So I do know, I mean, obviously, I first want to go see who's out there, right. So I'm going to go look for local group members. Okay. I want to get the name right. And then I also want local group members and the group right, so maybe I should do these in the other direction. So I'm going to run this. We'll just call this local admin. So this is how I start this stuff out, right? I do that and I'm like, Okay, so here's the admins, ministers Group, a bunch of groups. So I need to obviously be the administrator. So the first thing I'm going to do is copy that because there's no way I can type administrators in any fashion. So I am going to go in and add that local group member or the group contains administrators. Okay. So now, here's all the administrators that I've got out there. Okay, and so at this point, that's it, I'm going to do another regular expression, which ones I don't want to see. So again, back here, I'm going to do administrator and then probably, you know, bring in that. So we'll add another filter here, we're local group name, does not match expression, and we'll put in administrators. And we'll put in brig, two G's and we'll run it again. So now I've got it down to so I'm going to start eliminating and eventually I am going to have a report that just has my local administrators that are the ones that I don't want because you know, Briggs it Okay, administrator administrators good. I don't know who this Quintana guy is, we probably should get rid of that admin access, right?

    Jordan  26:21 --- And I think maybe because this is just saying, which group which user if you add the column for computer name, oh show which computer also has it?

    Lex  26:30 --- Well, I'm gonna get it narrowed first, right? And then I'm gonna go and show the computer so I can see but I guess we need to go do that. Now. Let's go add computers to our computer name. We'll put that up top. Now we got broken down by who's administrators on what computers? Remember? I changed that to the group name there. Alright, there it is. Nope, nope. But the administrator definitely shouldn't be on there. So you know cuz I think he missed you messed up my vibe, dude.

    Jordan  27:07 --- I messed with your,

    Lex  27:08 --- your system, my system of awesomeness. You know, go back to what I was doing.

    Jordan  27:16 --- Alright. I'll sit here and I'll keep my mouth shut.

    Lex  27:19 --- Well, okay, at this point, you limit it. And then you go add your computers. And you should be saying the machines have admins that are not on the approved list. So thank you, Jordan. If I could break it for you. Thank you for messing with my vibe there. Anyway, to do another question or another couple questions.

    Kelly  27:38 --- Now let's do a speed round. We have four questions in the queue. Guys, network admin is disabling PowerShell via GPO. How does the GPO affect PDQ inventory and PDQ Deploy installing packages like Windows 10 cumulative update or chrome, Daniel C.

    Lex  27:58 --- disabling PowerShell.

    Jordan  28:00 --- So I don't know if it's disabling or if it's just setting it to where it's restricted or requires a signature assert, and I think the package we build does include a cert. But the way the deploy works is it sends a under the bypass flag, which only works up to user level settings, Group Policy overrides bypass. So if they have something on the group policy setting, that doesn't even take signed scripts, then it is absolutely going to block it, you're either gonna have to allow sign scripts or make an exception for PowerShell from the IP range that has your deploy server.

    Lex  28:37 --- What he said, Yeah. What else did we get?

    Kelly  28:43 --- All right. Hey, guys, is there any follow up to the agent for inventory or deploy? Or how would be the best way to deploy and monitor off site computers? Thank you, Luke be

    Lex  28:54 --- follow up the agent. Yes, there is an agent in process of being built right now. leave it at that. We're working on it. We've heard you we are doing it. Okay. How to get the remote machines. Currently, you're going to need some type of network layer to get to it whether it's a RAS or a VPN, again, you're going to need to open your ports across there, you know, the ones that allow you to do file and print sharing internally and answering a ping. And obviously, with VPN and some others, you're going to need to do some probably fairly aggressive scavenging on your DNS server. So again, some moving parts there, but it is possible we've dealt with a lot of clients and if you get stuck, I would check out go to work you our YouTube channel and look up VPN. There's a short four minute video if you're really good with your VPN stuff. We're Jordan I touch on what needs to be opened and then there's a longer one, or Josh does a really good explanation of how all of it works together. So that's where I would look.

    Kelly  29:56 --- Dear Lex and Jordan what criteria causes a machine to fly? For a reboot, I have a machine showing yes needs reboot, but there are no Windows Updates pending a reboot on those machines. Thanks, Greg Kinnear,

    Lex  30:09 --- if I remember correctly, the reboot flag is it's in the registry gets tagged. Right.

    Jordan  30:13 --- Yeah, I think it looks in a couple locations. I can't remember all of them. But I know it looks in another four or five different spots for it normally is flagged for needing reboot, not necessarily just that there are updates pending. Yeah.

    Lex  30:24 --- So again, you know, depending on who goes in and tags that have flags that it could be more than a Windows Update statement needs a reboot

    Jordan  30:33 --- real quick on our non admin users that our guests didn't have it. Someone said in the chat that we just had added an extra s to the administrator, which is why we're still pulling those in. Oh, so it was still correct. We just had a typo in our regular expression.

    Lex  30:49 --- Thanks, guys for fixing my typing, again.

    Jordan  30:53 --- Well, I just figured it'd be better for people to know that it was going to function. It was our mistake, not the products. Yeah.

    Lex  30:59 --- It's always my mistake, not the products. Let's be real, right?

    Kelly  31:02 --- It always boils back down to typing type really does. You know,

    Lex  31:06 --- one of these days, they're gonna just walk me out Hand me my box. You're too bad at typing. You're Alex.

    Kelly  31:14 --- We got our final question of the day, this scan status window anyway, to add the date time of failures mall.

    Lex  31:27 --- I would say Well, let's see, if you go look in the computer screen you can see the last six see last successful scan.

    Jordan  31:37 --- That's not for

    Lex  31:39 --- for failures, though.

    Jordan  31:40 --- I can't think of a way to do it without setup. So if I mean, since it's a scan as you're doing there, if you add to your if you customize your scan profile, to have a PowerShell thing that basically just does a get-date, and then adds that to a custom variable that is the PowerShell scan that pulls in there. But that's going to be for every scan and actually know that fell on and fell on failed scans. I was gonna say,

    Lex  32:07 --- I think you're Yeah, yeah. I guess my question is, it fails. Date and Time men are easy enough to kick off again. I mean, I'm trying to think of the thought process of You know what, you do the failed one. I don't know. I don't know. There's any easy way to get that we can't think of one right off top of our head but main trying to understand which processes so

    Jordan  32:29 --- my dad has not the way I wanted to end this webcast. Wow. Yeah.

    Lex  32:33 --- Okay. Do we have any questions that we can leave with a positive answer that we can Yeah, man, you got to drink.

    32:41 --- We're gonna stump. He got a drink.

    Jordan  32:44 --- There's one more question now. How much can you bench? How much?

    Lex  32:46 --- There we go? How much can I match? Recently, not a lot most of the time over 400. I usually start around four or five and go up from there.

    Jordan  32:55 --- And in onsuccess

    Lex  32:58 --- Boom, anywho. Thank you guys for watching. Again, one of the nice things about watching this webcast live is you get to see truly how bad a typist I am. And he at least gets to see how we troubleshoot to get the answers and stuff we do want. Thank you guys for watching. And hey, next week, the studio won't be here. We'll be somewhere else. So appreciate you watching them lapse. We'll catch you all later.

    Kelly  33:20 --- Thanks for joining our webcast today. And yes, we will be back next week, slightly different format, but we are looking forward to it. Thanks again. Have a fantastic week and we'll see you here next time. Bye bye.

    company JJB
    JJ Bateman

    JJ is a technical creative. He finds joy in programming, automation, and in participating in the artistic sides of things. You'll often find him drinking on Thursdays on the PDQ webcast, rambling and raging remotely at the Bermuda Triangle/heisenbug-tier tech at the studio in SLC.

    Related articles