Version 2

    Hello Guys,

     

    Not sure if this exists already, sorry if it does. I wanted to create a report which lists the nodes which have never been backed up since they were added on NCM. NCM web soncole already does this if you click on the pie chart for devices not backed up since import, but there was no canned report for that if you wanted to run it separately.  I am not 100% proficient with SQL yet, so my query is probably slightly expensive. If anyone can make it better, please do and share.  I wanted to add this under NCM but there was no generic Reports group.

    EDIT: Forgot to mention, you will need to update the names of the equivalent Database instances according to your own, via editing the file.

     

    Thanks,

    Alex