Symantec Management Platform (Notification Server)

When I use resource manager to view a resource summary, I see a lot of information I would like to use in custom reports.  What SQL table contains this information?

The resource summary data is spread around through many tables.

The best way to find any "piece" of information you want is to go into resource manager, go to view the inventory data, and find your specific information in those fields.  The tree on the left is named the same way the tables are named in the DB for that specific type of inventory data.  You can then query against those tables and pull the data you want.

If that isn't enough to get you going, let us know what types of information you're looking for and we'll help.  Just remember that the summary is just that - a summary, pulling from several tables, not one.

Thanks for the great information.  I understand that I need to pull information from multiple tables, but for a SQL newb it gets difficult.  My execs have me creating custom reports to match exactly what they want.  I have been trying the method you recommended but it just seems like I am chasing my tail.  I will keep working on it.  Thanks again.

It's nice to have a very flexible product, untill you're under pressure to flex it.  The good news is that very soon you will no longer be a SQL noob.  :D

If you're having difficulty with a specific issue or piece of information, let us know.  Also, if you're really new to SQL, clone and try modifying some of the canned reports to get an idea on how the sql "guru's" do things.  They're not always perfect I'll grant you, but I learned a LOT of ideas by following those.