All,
I have a little bit of an issue where someone changed a bunch of random devices to use a different view than the normal views we had assigned. Is there a way to create a list of all the devices by view type? SWQL, report, etc.? I need to change all the devices back...and yes, I've removed this person's customizing ability!
D
If you go to "All Settings" and click on "Views by Device Type" it'll display all the views assigned to what device type
deverts I understand now. Let me see if I can cook something up
EDIT 1*************
deverts, so I was able to develop a query that will display the view name for any device where the view has been statically assigned if on the node propertied screen it is set to "default" the query will return nothing, as it is being determined by the "Views by Device Type" page. Let me know if you have any issues or questions
SELECT n.caption AS [Node Name], v.ViewGroupName AS [Assigned View Name]
FROM Orion.NodeSettings ns
join Orion.Views v on ns.SettingValue = v.ViewID
join Orion.Nodes n on ns.NodeID = n.NodeID
where SettingName = 'ViewID'
