Creating Custom Table and Resource in NPM

Question

We have added address information as Custom Attributes to nodes at each location.  While this works, it really doesn't make sense from a management standpoint.  I would like to create a location table that I can use to pull this information into a resource on the detailed node screen.  I have a few questions:

1. Is it OK to add a custom table to the NPM database, or should it be created in a separate database?

2. Is there any info on building a custom resource that will query my custom location table using an attribute in the nodes table (SiteName)

3. Has anyone done something similar that can offer tips?

Thanks

-=Dan=-

Yossarian · Answer

ad 1., it is not directly supported, but I don't see any problem, if you use name that is unlikely to be created in future by Orion.

ad 2., Custom SWQL resource cannot support your own table, unless you do some more black-magic (= configuring information service), I don't recommend that, however, if you insist on it, I can give you some tips how to.

Jan_Pelousek · Answer

ad 2. Yes. you can use ${NodeID} macro in the where condition similar way as described on