i need querry to list me devices wich configs are not backuped. Does anybody some kind of sample for this?
How about something like this?
select AgentIP from Cirrus.Nodes where NodeId not in (select NodeId from Cirrus.ConfigArchive)