1 of 1 people found this helpful
Try this one in a custom query on your node details page. I set the logic so that it displays the critical icon if the last backup is older than a day, but depending on how frequently you save your configs you may need to adjust the line with the case on it.
max(downloadtime) as [Last Backup], ConfigType
, case when daydiff(max(downloadtime), GETDATE())>1 then '/Orion/images/StatusIcons/Small-Critical.gif'
end as [_iconfor_Last Backup]
FROM NCM.ConfigArchive ca
group by ca.NodeProperties.Nodes.Caption, configtype
order by caption, configtype
I was a little bit disappointed to see that it still seems to work after I set my account to have no access to NCM, suggests that SWQL may bypass those account restrictions on the account settings page. Luckily for you though.
Thanks Mesverrum. I'll give that a go.
Thanks Mesverrum. That's exactly what I needed.