micheal100 · Principal Solutions Architect · ✭✭✭✭✭

Yeah, figuring out what to return in a lot of functions I've written is pretty tricky: I've a HUGE list of things I want to re-write for proper pipelining, and to make use of try/catch etc <cough> PowerOrion </cough> . But in this case an array of the files returned definitely makes sense. The one thing that would be…

Hi Kevin, nice script looks good, worked first time for me so always a plus! A few suggestions if I may: * instead of the write-host I'd use the write-warning (I'm nit-picking here,I see you used it in other places). As Jeffrey says, write-host is bad * I think the SWQLQuery variable is declared twice. It runs fine, not…

hi darcydressell44​, this is a web report, you can simply import the file under "Manage Reports", and run it as needed, or schedule it. If you edit the imported report, you can see the raw SWQL, which you can use in various web resources, call from scripts, etc.

Hi greg.cheal​, info on the agent repair options is available here: Repairing and Maintaining the Windows Update Agent - SolarWinds Worldwide, LLC. Help and Support

This is outside of the SDK, but simply running a network discovery on the subnets every few hours is a good way to add in those servers automatically, if it doesn't need to be scripted.

Hi dgsmith80​, you should get an email later this week confirming final details, but if doing the technical track then yes, a laptop will be needed to access the lab resources. Look forward to meeting you!

Thanks for the feedback Richard. It's definitely worth the effort, like anything it takes a bit of effort at the start. But if you pick a task that you can assign a dollar value to, and work out how much time and therefore money you can save over the year, from automating it, it really helps give some impetus.

I use mine daily. It's amazing where a toddler can bury keys..

This is true. It's also a reason why I use a tile app on mine.

Thanks Richard. There's a bit of trial and error alright, nothing complicated. But it's amazing how much the simple things like having something like allergy tablets or paracetemol, when you're stuck on an 8 hour flight, can make all the difference. I remember one colleague came all the way from the US for a European trade…

Sorry Vignesh , I might be missing something, but why can you just use the "Time of Day" when creating the alert?

Hi Andrewm, section 4.3.2.2 in the administrator guide covers this section. From the help for managed computers "Computers with a yellow shield indicate a computer that has failed more than five times consecutively to be inventoried. The yellow shield can also be displayed if the EminentWare system had issues retrieving…

Hi netspacer1​, that's correct. However, I believe the requirement is to trigger an alert, so it's possible to use the virtual or physical memory values to trigger alerts, rather than the warning/critical values.

Hi Thomas, if you use the Process Explorer, you can just add in the service's process to a new or existing templated, that will give you the physical memory

Hi Alan, did you try replacing the whitespace with underscores?

Hi max348​, I'm assuming you have both SAM & DPA deployed and connected? Have you connected the database instances using the client relationship functionality, under Settings-> Database Performance Analyzer, in the Orion console?

There is nothing out of the box, but you could build out a PowerShell monitor using this FTP client. I did a quick test, and it's possible to pull back the last modifed date, so I think that's the way to go. PS C:\temp> $folders = Get-FTPChildItem -Session $Session PS C:\temp> $folders[0].ModifiedDate 06-21-14 09:59PM

Hey @nick_scott, when the $query returns a number of objects, it'll store them as an array $query.gettype()IsPublic IsSerial Name BaseType -------- -------- ---- -------- True True Object[] System.Array Each element in the array however is a string $query[0].gettype()IsPublic IsSerial Name BaseType -------- -------- ----…

Hi khiyal, are you running a licensed copy of Patch Manager, or is it a trial?

You don't actually need to use the SDk in this case. When creating alerts (which are checked by default every minute), you can have one or more actions triggered. These could include sending gets/posts to a web service, or perhaps running a script. You can pass variables from the alerting object to the trigger action.…

Hi eherrera2528​, I made some changes at the weekend. I'm rebuilding all the existing functionality, but in the meantime can you download the latest .psm1 and .psd1 and replace those on your disk. OrionSDK/Samples/PowerShell/PowerOrion at master · solarwinds/OrionSDK · GitHub And can you just respond back if the changes…

Hi, could you post a screenshot of the view?

Thanks chrisagardner63​. I'm currently looking at options on making this module a lot more robust, I'll definitely dig in to this in more detail when I get a bit of time. I really appreciate the feedback, let me know if you hit any more hurdles, once I get this updated I'll reply back, just in case you can test the other…

Hi chrisagardner63​ I fixed a couple of bugs, can you download the latest version of the .psm1 and .psd1 from github, and replace those files on you disk and unload & reload the module. OrionSDK/Samples/PowerShell/PowerOrion at master · solarwinds/OrionSDK · GitHub

Hi Chris, apologies for the delay in replying. I'm afraid this isn't possible, the 3rd party content will be pulled from the upstream server, regardless of whether MS updates are pulled from the upstream or Microsoft. Basically this is how WSUS handles the content, I haven't seen an official explanation, but I assume it's…

Here's an example I've used before, SELECT distinct [NodeID] , count (distinct([CPUIndex])) FROM [dbo].[CPUMultiLoad] group by nodeid There's also an older report that has similar code Number of CPU Core SQL report - SolarWinds Worldwide, LLC. Help and Support

Hi takachicha​, please see this previous thread Re: Remove old versions of Java 8

Interesting question xtraspecialj​! It's actually something I was thinking of doing a post on at some stage (my plan is to do some tests with a few different techniques, and then compare the efficiency of the approaches). If we consider the 2 approaches below for example, I know the second approach is faster than the…

Hi rosscrawford​, sorry for the delay. Simply select the computer group and then in the action pane you can select "approval delegation". This will allow you to add in AD groups to approve the updates

Ok, so you have a SQL monitor (not shown), that when triggers sends a formatted email, built using SQL contained within a PowerShell script? Easiest thing is just to save the script as a .ps1, and then use the "execute a program" calling powershell.exe and passing the script's path on the cmd line. See the following for…