Hi all,
I've been tasked with creating a report showing all of the nodes in NCM and the date of their last config backup.
I'm playing around under the 'Reports' tool in NCM but no luck as of yet
Any help would be greatly appreciated
Disclaimer, this is from the airport on my phone, so I am not 100% as I am doing this from memory, but try this:
SELECT
Nodes.NodeCaption AS 'Node',
ConfigArchive.ConfigType,
MAX(ConfigArchive.DownloadTime)
FROM
[ConfigMgmt].[dbo].[Nodes]
JOIN
[ConfigMgmt].[dbo].[ConfigArchive]
ON
Nodes.NodeID=ConfigArchive.NodeID
GROUP BY
Nodes.Caption, ConfigArchive.ConfigType
ORDER BY
Nodes.Caption
Replacing [ConfigMgmt] with whatever your NCM database is named.
ok, now that I am in front of a DB, here is the final query for you (thanks to Steven Klassen for the assist with the join)
SELECT Nodes.NodeCaption AS 'Node', ConfigArchive.ConfigTitle AS 'Config'FROM [ConfigMgmt].[dbo].[Nodes]JOIN [ConfigMgmt].[dbo].[ConfigArchive] ON '{' + CAST (Nodes.NodeID AS VarChar (100)) + '}' = ConfigArchive.NodeIDORDER BY Nodes.NodeCaption
Replacing [ConfigMgmt] with whatever you have named your NCM database.
This new format will give you results like the attached:
You are most welcome!
--
Steven "MrXinu" Klassen
Hosted Web Help Desk Engineer | Loop1 Systems, Inc.
