We use the DPA tool to monitor our sql server. I have sucessfully connected to and queried our Orion instance with the SWQL tool. Although i do see a small number of DPA objects in the Orion server, it doesn't appear to be very many.
Do I need to connect to a different server to see all the DPA objects? I know our DPA is running on a separate server, if that means yes it does need to connect to that separate server, does that mean I have to ensure that SWIS is running on that server?
DPA is pretty much a standalone tool outside of Orion, for the purposes of the integration they port over a small subset of the information from DPA to SWIS, but the bulk of the meaty data stays in their database and cannot be accessed via SWQL and the Info Service. You would have to query the DPA repository database directly via SQL for anything more detailed than what you were seeing in SWIS already.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.