Dashboard and Performance question

[Sean_m_Taylor]

Is there a way to put the performance stats for servers on the dashboard? I found a way to sort of do it with the iframe but that is not a great method of doing it.

Is there a way to export the performance chart into a report?

[ivonin]

Sean m Taylor wrote:
...
I found a way to sort of do it with the iframe but that is not a great method of doing it.
...

Please tell me how you did it?

[deziner22]

This report shows network data based on ID your id's may be different. Again data is of last 24 hours, this can be adjusted by the getdate value last item.


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblPerformanceCountersScanMetricIdentifier.Name,
tblPerformanceCountersScanMetricIdentifier.Id,
tblPerformanceCountersScanMetric.Value,
tblPerformanceCountersScan.ScanDateTime
From tblAssets
Inner Join tblPerformanceCountersScan On tblAssets.AssetID =
tblPerformanceCountersScan.AssetId
Inner Join tblPerformanceCountersScanMetric On tblPerformanceCountersScan.Id =
tblPerformanceCountersScanMetric.PerformanceCountersScanId
Inner Join tblPerformanceCountersScanMetricIdentifier On
tblPerformanceCountersScanMetricIdentifier.Id =
tblPerformanceCountersScanMetric.PerformanceCountersScanMetricIdentifierId
Where (((tblPerformanceCountersScanMetricIdentifier.Id = 4 And
tblPerformanceCountersScan.ScanDateTime > GetDate() - 1) Or
(tblPerformanceCountersScanMetricIdentifier.Id = 18 And
tblPerformanceCountersScan.ScanDateTime > GetDate() - 1) Or
(tblPerformanceCountersScanMetricIdentifier.Id = 28 And
tblPerformanceCountersScan.ScanDateTime > GetDate() - 1) Or
(tblPerformanceCountersScanMetricIdentifier.Id = 32 And
tblPerformanceCountersScan.ScanDateTime > GetDate() - 1) Or
(tblPerformanceCountersScanMetricIdentifier.Id = 54 And
tblPerformanceCountersScan.ScanDateTime > GetDate() - 1) Or
(tblPerformanceCountersScanMetricIdentifier.Id = 60 And
tblPerformanceCountersScan.ScanDateTime > GetDate() - 1) Or
(tblPerformanceCountersScanMetricIdentifier.Id = 67 And
tblPerformanceCountersScan.ScanDateTime > GetDate() - 1) Or
(tblPerformanceCountersScanMetricIdentifier.Id = 72) And
tblPerformanceCountersScan.ScanDateTime > GetDate() - 1)) Or
(tblPerformanceCountersScanMetricIdentifier.Id = 102 And
tblPerformanceCountersScan.ScanDateTime > GetDate() - 1)

[deziner22]

I was able to get this report going it gives you all of the performance data for the last 24 hours, it has basic information.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblPerformanceCountersScanMetricIdentifier.Name,
tblPerformanceCountersScanMetricIdentifier.Id,
tblPerformanceCountersScanMetric.Value,
tblPerformanceCountersScan.ScanDateTime
From tblAssets
Inner Join tblPerformanceCountersScan On tblAssets.AssetID =
tblPerformanceCountersScan.AssetId
Inner Join tblPerformanceCountersScanMetric On tblPerformanceCountersScan.Id =
tblPerformanceCountersScanMetric.PerformanceCountersScanId
Inner Join tblPerformanceCountersScanMetricIdentifier On
tblPerformanceCountersScanMetricIdentifier.Id =
tblPerformanceCountersScanMetric.PerformanceCountersScanMetricIdentifierId
Where tblPerformanceCountersScan.ScanDateTime > GetDate() - 1

[AlbertD]

Agree with you guys here. We definitely need some Performance Reports of sorts. Even if they aren't fancy widgits, just some simple reports that can identify the devices that are being pushed to their limits.

Perhaps this is something that someone more familiar with SQL Queries can put together. I tried the report builder, but wasn't having much luck.

[Esben_D]

AlbertD wrote:
Agree with you guys here. We definitely need some Performance Reports of sorts. Even if they aren't fancy widgits, just some simple reports that can identify the devices that are being pushed to their limits.

Perhaps this is something that someone more familiar with SQL Queries can put together. I tried the report builder, but wasn't having much luck.

I've been working on a few. Once they are ready I'll put them on the forum. But it might take some more time since I've been too busy to complete them.

[deziner22]

I've been trying to get a report working also but haven't been able to figure it out. I've been working with the performance tables with no luck.

Manually looking at asset performance data is very time consuming.