Danny,
Followup on Angelo’s question, just to clarify for me:
Intent:
We intend to have ServiceNow be the central asset repository by having its fields updated from various backends such as MI, SCCP etc. to indicate if a device is encrypted, tagged, if user is active, etc etc
Consensus from our ServiceNow admin is that our SN implementation could not keep up with a large and sustained influx of individual pull queries from CPPM to SN and be able to respond within an acceptable time period. Seems in our environment this would require multiple recursive queries per because of how we nest our fields, as I recall. Therefore one approach being discussed is to have a separate DB get periodic pushes from SN matching the fields we need CPPM to check against. CPPM would then query the separate DB for determining if all criteria for a particular Role are met.
Question(s):
1. Could we use the CPPM local DB for this purpose
2. Could SN periodically push as a dump (or CPPM pull as a periodic dump) selective attributes, that we create and customize on SN, from various fields within SN to the CPPM local DB
3. Would there be a threshold we would have to be aware of where the CPPM internal DB may not be able to scale to in relation to date store or query rates?
4. What would be a realistic refresh time for this so we have an idea of the period that stale data may exist between refreshes
Any other caveats we would have to take into consideration?
Thanks
Chris