i am looking for some custom scripts to pull information on perfomance data counters being collected by OpsMgr. Does anyone have any scripts they are currently using?
Here's some sql to get you started:
Works with SCOM 2007 SP1, SQL 2005 backend. Other performance tables in the data warehouse are Perf.vPerfHourly , and Perf.vPerfDaily