Does anybody know if it is possible to create a chart showing the list of devices that have not been backed up over a certain time frame? The only thing I have been able to find is the 'Overall Devices Backed Up vs. Not Backed Up' pie chart.
We currently do this already however management want this information along with other specific details presented on a single page in NPM/NCM.
I was able to figure it out this morning:
Here's the Datasource I built. I had to exclude some vendors that we don't use NCM to backup (I know it's not pretty at the moment):
Here's how I did the table layout:
This may not be the exact answer but i made a report a while back with a SWQL querry that i think i found here on Thwack.
SELECT OrionNodes.Caption, OrionNodes.DetailsUrl, OrionNodes.Status, OrionNodes.ChildStatus, OrionNodes.Vendor, OrionVendors.Icon, OrionNodes.IP_Address, OrionNodes.IPAddressType,OrionNodes.MachineType, NcmConfigArchive.DownloadTime FROM NCM.NodeProperties AS NcmNodeProperties INNER JOIN Orion.Nodes AS OrionNodes ON NcmNodeProperties.CoreNodeID=OrionNodes.NodeID INNER JOIN Orion.Vendors AS OrionVendors ON OrionNodes.Vendor=OrionVendors.Name LEFT JOIN NCM.ConfigArchive AS NcmConfigArchive ON NcmNodeProperties.NodeID=NcmConfigArchive.NodeID AND NcmConfigArchive.ConfigType='Running'
You can then create a table and sort it by Time/date so you can see those devices that have not been backup up.
Hope this helps
This resource is available out of the box if you search for overall devices backed up vs all devices
Thanks for this. I'm not very familiar with SWQL queries unfortunately. I've tried adding it as you have suggested however can you please explain how you managed to get the 'Last Running Backup' column information in your screenshot?
In this case I don't need a graph of overall backed up devices but rather a list of devices that have not backed up for the last 24 hours.
When you do the backup of the configs, you can get it to send you a report in an email. In it you can see which ones were successful and not successful. You can also click on the "not backed up" bit in the pie chart and it will take you to a page called "Overall Devices Backed Up vs. Not Backed up.
