vdubn

Comments

  • Well, then I guess this will just get added to all of the threads where this has been requested as a feature request. What a bummer, as it appears as though this has been requested at least as far back as 2010... In the meantime, is there a way to remove the hyperlink that is automatically placed on all columns (at least…
    in SQL Report writing - How to Sort By columns? Comment by vdubn October 2012
  • Hi Mark, First create a template using the browsing method and assign it to the desired nodes: * In the APM Settings, click Find Processes, Services, and Performance Counters. * Select the component monitor type: Windows Service Monitor. * Click NEXT. * Browse the list of services and check the boxes for the services to…
    in Simple Windows Service status monitoring asistance Comment by vdubn February 2012
  • Yea, I saw those, and they can get me lists of data, like all disabled users, all locked out users, etc. I need to get the name of the user that was locked out, check if its one of our admin/system accounts, and then notify people based on which user it is. I did some work late last week, with an Orion tech, and it looks…
    in How to Create a Monitor to Alert on a Locked AD Account (Windows Server 2008 R2) Comment by vdubn February 2012
  • Yea, I understand that, but I figured that there had to be a way to pass a variable back to change the "ORDER BY" statement, either by setting a variable in the SQL Query itself for "ORDER BY" and then passing a new variable based on the column that you click. So, if you enter the URL of the report you are using (so that…
    in SQL Report writing - How to Sort By columns? Comment by vdubn October 2012
  • The name of your db may be different, but here is a QQL query I have created for just what you are looking for, these generate reports in Orion, and you could probably build a custom view on a page with these as well. Hope this helps: List of Non-Compliant Machines (our laptops all start with LAP-, hence setting the LIKE…
    in Does Anyone Know Where I Can Find Orion / PM SQL Query Code? Comment by vdubn April 2015
  • If you have either of Orions NPM or APM/SAM products, you can use the Report Writer to create a SQL report that will show you all machines (or just the top 10 or whatever) that still need updates. By default, if they are Windows patches, it will only show patches that are Approved. If they are 3rd Party, then all 3rd Party…
    in Approved Patch view Comment by vdubn April 2015
  • Do you have any of the other Orion products, like APM/SAM or NPM? If so, you can build a custom SQL report using the Report Writer built into NPM. I have tried to use the custom report writer that is in the Patch Manager console, and the OSQL (I think that is what the Orion SQL language is referred to) is very confusing,…
    in Custom Report - Computers Needing Patches Comment by vdubn April 2015
Avatar