locked
Export list of Web Application Availability URLs from management packs RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Does anyone have a good method for exporting a list of all web application availability URLs from all management packs in a management group?

    Thanks,

    Jonathan

    Friday, February 28, 2014 10:37 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    You may try this SQL statement

    select m.mpfriendlyname, was.parameters_GUID, was.displayname from
    managementpack m inner join discovery d on
    m.managementpackid = d.managementpackid inner join
    discoverysource ds on ds.discoveryruleid=d.discoveryid inner join
    discoverysourcetotypedmanagedentity ds2 on ds2.discoverysourceid=ds.discoverysourceid
    inner join MT_Microsoft$SystemCenter$webApplicationSolutions$singleURLTest was
    on was.basemanagedentityid=ds2.typedmanagedentityid where m.mpfriendlyname='Test Management Pack'

    The URLs entity is stored in the parameters_GUID and you should find out the value of GUID in your operations manager DB.

    Roger

    • Marked as answer by stringstream Monday, March 3, 2014 8:10 PM
    Monday, March 3, 2014 7:08 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Plz check below link

    http://discussitnow.wordpress.com/2013/12/18/get-a-list-of-monitored-urls-out-of-scom-via-powershell/

    hope this helps

    Faizan

    Saturday, March 1, 2014 7:47 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You may try this SQL statement

    select m.mpfriendlyname, was.parameters_GUID, was.displayname from
    managementpack m inner join discovery d on
    m.managementpackid = d.managementpackid inner join
    discoverysource ds on ds.discoveryruleid=d.discoveryid inner join
    discoverysourcetotypedmanagedentity ds2 on ds2.discoverysourceid=ds.discoverysourceid
    inner join MT_Microsoft$SystemCenter$webApplicationSolutions$singleURLTest was
    on was.basemanagedentityid=ds2.typedmanagedentityid where m.mpfriendlyname='Test Management Pack'

    The URLs entity is stored in the parameters_GUID and you should find out the value of GUID in your operations manager DB.

    Roger

    • Marked as answer by stringstream Monday, March 3, 2014 8:10 PM
    Monday, March 3, 2014 7:08 AM