Filtering Node Custom Field

Ty_McCoy

I just started a new position at a new company, and one of my first tasks is to take a look at my department's current environment.  At this current time there is not an individual field setup that could easily identify a server and which team manages the server.    
I noticed that under custom properties for the Node's section there is a field for "Application_Support_Team" I am thinking of using this field to identify the server's that my team manages, but I am having issues locating the table where this data is stored so that I can develop a query to filter info from.  

Can anyone let me know what table the custom properties are stored for the Node, and if this is the proper field, I should be using to filter servers both in reports and dashboards.  

Thanks,

Ty

stevenstadel

Custom properties have their own table because different elements can have their own custom properties. In the SDK you can see the table is called Orion.CustomProperities. If you are making a query you can use the linked values to automatically grab the associated data. This is a quick example to pull up a custom property in a query.

SELECT TOP 10 Caption, IsServer, Nodes.CustomProperties.Application_Support_Team FROM Orion.Nodes as Nodes WHERE Nodes.CustomProperties.Application_Support_Team like 'Team X Server'