Partager via

SCOM SQL queries

  • Article

<!--[if lt IE 9]>

<![endif]-->

Comments

  • Anonymous
    November 14, 2016
    Thank you!
  • Anonymous
    November 14, 2016
    Excellent! Thx!
  • Anonymous
    November 15, 2016
    Thanks for providing updated SQL queries.!!
  • Anonymous
    November 22, 2016
    Excellent! Thanks
  • Anonymous
    November 25, 2016
    Thank you Kevin.
  • Anonymous
    December 19, 2016
    Dude you are the absolute man when it comes to ops mgr. I am going piggyback off these queries to create tableau visualizations in an IT Ops dashboard for our organization. Thanks again.
  • Anonymous
    December 28, 2016
    excellent help !
  • Anonymous
    January 10, 2017
    Many thanks!
  • Anonymous
    January 16, 2017
    Kevin, I took the liberty of wrapping your wonderful queries into an old SAPIEN Technologies PrimalForms (Community Edition) GUI for everyone's convenience. I use this GUI everyday, and am very satisfied how it performs. I also have included in the script the Out-Excel function adapted from "The Scripting Guys". It can be remarked or left in as well as the Out-String to $RichTextBox1 as desired. I hope everyone enjoys the GUI as muck as I do. Happy SCOMing, Dave KH - I deleted the script from this post because it made reading comments impossible. See technet gallery link.
    • Anonymous
      January 25, 2017
      Added to TechNet Gallery - https://gallery.technet.microsoft.com/site/search?f%5B0%5D.Type=RootCategory&f%5B0%5D.Value=SystemCenter&f%5B0%5D.Text=System%20Center&sortBy=Date
      • Anonymous
        January 27, 2017
        Sorry, wrong paste of the gallery upload this should be correct.https://gallery.technet.microsoft.com/SCOM-2012-2016-Database-990ec847
    • Anonymous
      February 13, 2017
      THX Kevin...Sorry for the script dump on the blog...was over excited to get it posted...Dave
  • Anonymous
    February 03, 2017
    Hey Kevin,How can we find members of a given group when we query Dataware house database table. below one gives the information when we query database tableselect TargetObjectDisplayName as 'Group Members' from RelationshipGenericView where isDeleted=0 AND SourceObjectDisplayName = 'All Windows Computers' ORDER BY TargetObjectDisplayName
    • Anonymous
      February 03, 2017
      I just added a huge section with examples of how to do just that. I have had that forever.... this blog format is getting out of hand... it makes it hard to edit in Live Writer. I hope it doesn't get a lot bigger. :-)
      • Anonymous
        April 11, 2017
        Hi,Is there any way to get the list of database users from all the connected servers and instance as report on monthy basis
  • Anonymous
    February 25, 2017
    Thanks for the queries!I am trying to do a select from my QRadar SIEM against the data base to retrieve important security events like "user locked out" "user added to group" etc.I played around with the "EventView" but cannot find the events I am looking for (locked out user, while watching the table). The SCOM operator guys created e-mail alerts if these events raise, but I cannot see/resolve the relationship in the data base.anybody tried anything similar before?ThanksBoris.
  • Anonymous
    June 23, 2017
    I am looking for a query that spits out all the hostnames that have "checked in" in the past x number of days.Is there such a thing?Thanks
    • Anonymous
      June 23, 2017
      We collect the 6022 event, which is logged every 15 minutes on all agents. So just use the event queries, and you can look for servers that have at least one events within x timeframe.
      • Anonymous
        June 26, 2017
        Excellent! Thanks for the reply
  • Anonymous
    August 04, 2017
    The comment has been removed
  • Anonymous
    August 09, 2017
    Awesome !Thanks for sharing.
    • Anonymous
      September 24, 2017
      Hi ,I just want to get the failed backup jobs for all the SQL server from SCOM any help?
  • Anonymous
    October 05, 2017
    Hi Kevin,Please suggest me any query by using that i can get all the rule and Monitors of any particular MP.
  • Anonymous
    October 10, 2017
    HI KevinCan we get management pack name when we give event id
  • Anonymous
    December 10, 2017
    How go pull network work device name, ios version,ip address,location,serial number from scom 2012 database, really need your help. Thanks
  • Anonymous
    February 04, 2018
    The comment has been removed
    • Anonymous
      February 04, 2018
      Ahha, i found the reason. thanks
  • Anonymous
    March 16, 2018
    A useful query I use for my Dashbaord is the count of Unhandled Alerts Critical or warning - just change the Severity to 1 for Warning.select count(*)from AlertView where ResolutionState = 0 AND TicketID is NULL AND Severity = 2AND LanguageCode = 'ENU'
  • Anonymous
    April 03, 2018
    The comment has been removed
  • Anonymous
    November 23, 2018
    Hi All,Is there any way, we can get the all rule and monitor and discovery etc which is linked with "xyz" group for overrides / alert suppression?.I used the mentioned below query which are fine but not giving the complete details.https://social.technet.microsoft.com/Forums/en-US/d04ab497-c3bb-4fa1-82c6-aeb50ce6346f/get-scom-rules-and-monitors-for-a-specific-groupauthoring-tab?forum=operationsmanagerauthoringthanks