TL;DR: Is there documentation or a location I can look to get the Raw Sql / Sql Queries being used in TSMM and/or Cognos?
I've been trying to like the Cognos portion of Monitoring, but I just can't seem to get what I need.
I'm not researching recreation of the basic reports (Daily Errors, Time taken, space used, etc) via Crystal Reports.
To recreate the reports, it'd be swell if I had access to the raw SQL (or as close to raw as I can peg) to try and get a baseline... I could then add the extra spices I need (For example: Space Usage... Broken down by Department)
I can find a healthy amount of the Sql needed for plain ole TSM... but I can't seem to find any good repositories of TSMMonitoring...
I've been trying to like the Cognos portion of Monitoring, but I just can't seem to get what I need.
I'm not researching recreation of the basic reports (Daily Errors, Time taken, space used, etc) via Crystal Reports.
To recreate the reports, it'd be swell if I had access to the raw SQL (or as close to raw as I can peg) to try and get a baseline... I could then add the extra spices I need (For example: Space Usage... Broken down by Department)
I can find a healthy amount of the Sql needed for plain ole TSM... but I can't seem to find any good repositories of TSMMonitoring...