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

  • Question

  • 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

  • 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

  • Saturday, March 1, 2014 7:47 AM
  • 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