Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Weekly Report with Statistic Data?

Hello,

I recently created a new poller that does a SQL Querey agaisnt a database on one of our servers. This querey pulls out data that is only available via the database on how the product is working. (SNMP or WMI has no information.

I'd like to create a weekly report that shows the highest value that the statistic reached daily. Is this possible?

Thanks!

Find more posts tagged with

poller

statistical_data

weekly_report

Accepted answers

FormerMember

Not possible now, but coming in 3.0

All comments

FormerMember

Not possible now, but coming in 3.0

ecornwell

Thanks Denny! I'm eagerly awaiting 3.0!

thurgoodj187

I use the solarwinds reporting stuff to query non solarwinds databases. Basically I gave the solarwindsnpm sql user read rights to the database and then ran queries against my VirtualCenter Database. They are on the same MSSQL cluster instance though. I don't know a ton about sql, but I think you can configure cross database server queries. An example of what I use this for would be a report of VM Snapshots (If you have some correlation between solarwinds and the other database (say caption = other database node name or whatever) you should be able to cross query a database):

Select
ve.name as "Datacenter Name",
ve2.name as "VM Name",
vm.power_state,
vs.snapshot_name,
vs.create_time,
vs.host_snapshot_id

FROM
((virtualcenter_PROD.dbo.VPX_VM vm
INNER Join virtualcenter_PROD.dbo.VPX_SNAPSHOT vs
on (vm.id = vs.VM_ID))
INNER Join virtualcenter_PROD.dbo.VPX_ENTITY ve
on (vm.datacenter_id = ve.ID)
INNER Join virtualcenter_PROD.dbo.VPX_ENTITY ve2
on (vm.id = ve2.ID))

order by vm.power_state