Get information through XML Query
Hi all,
I gathered some important information regarding the server hardware with your new feature "load from inventory". Now, I want to have an export where I can see my servers together with hostname, CPUs, memory etc.
The goal is to create an excel sheet with this information. I found the location of the needed information inside the database:
SELECT TOP 1000 [GroupName],[Name],[DATA]
FROM [Devolutions2].[dbo].[Connections]
ORDER BY GroupName
My problem is that the table [Devolutions2].[dbo].[Connections].[DATA] stores everything in XML. How can I query stuff like Architecture, Cpu, Domain and IP? I just wanna seperate the XML field into different columns. After that the data export is no problem. Do you have an example how to query that stuff?
Regards Martin
P.S.: Is it possible to execute "load from inventory" for every server with just one command?
All Comments (10)
Hi,
We don't have an example of splitting the Xml into column but I think we could add an export information to CSV in the application. Do you think it could help?
I will add a feature request for Batch Load from Inventory.
Regards
David Hervieux
Hey David,
the export of the additional information would be nice to have. Are there any plans for improving the Inventory stuff? For example take the information about the disks from the inventory report and write/save it in field hardware details. With some code there would be the possibility to run every night a batch update for inventory information in order to have the most recent data for a quick overview.
Regards Martin
Hi,
I will ask Hubert to add an option to fill the Hardware with the disk information.
For the batch that's something we want to add eventually.
David Hervieux
Hi Martin,
The "Load from inventory" button will now fill a new field called "Drives" in the hardware tab with the drive information. This will be available in the next version of RDM.
As for the batch, it's on our todo list as David said.
Regards,
Hubert Mireault
Hey Hubert,
thanks for the information and the quick response! These features are especially important for building a small CMDB and getting an overview of the IT landscape.
I'll try them in the next version and give you a short feedback :)
With regards
Martin
Hello Martin,
Good news, we'll also have a batch action for loading from WMI (select entries then right click > edit > batch edit > batch action > load from inventory). I'm not sure if it will be in the next version but it will be there soon.
Regards,
Hubert Mireault
Hey Hubert,
even better news! (: The information field for the drives is working good. Thank you so far for your work!
Regards
Martin
Hello guys,
I've tested the batch load from inventory. Something didn't work. I always got the following message "Error getting WMI Scope". For a single instance over the menu "properties > more > load from inventory" everything is fine.
Which credentials do the batch load use? I tried it 5 minutes ago for three servers in a batch, got the error code from above and locked my AD account because of using 3 times a false password....seems that there's some trouble..
Regards
Martin
Hello Martin,
I will ask Hubert to verify the credentials source.
Regards
David Hervieux
Hi Martin,
Sorry for the inconvenience with the batch action. The batch action uses the connection's credentials (not the tools) to fill in the WMI since it isn't used from the tools dashboard menu. There is an issue resolving credentials from the repository while using the batch action so this will be fixed in the next version of RDM. This should resolve your issue.
Regards,
Hubert Mireault