Devolutions ForumDevolutions Forum

CSV headers for asset information fields

CSV headers for asset information fields

avatar
(user deleted)
Disabled

I a working on creating our master CSV for computers to move our asset information over to RDM. I have figured out a few and used the ones i found on the "How to build a csv page", but I am struggling with ones that were not listed on the web page

Is there a list of all of the supported CSV fields within RDM? I am not looking for custom fields.

Any help would be great!!!

RDM-2021.1.38.0 x64

All Comments (4)

avatar
Eric St-Martin

Hello,

Thank you for contacting Devolutions support.

We don't have a list of all the information but it can be easily found. To retrieve the exact name of the fields, right-click on your session and select Clipboard – Copy. Note that you would need to have the fields filled in beforehand for it to show. As an example of info that can come out in the Clipboard. In theory, you would need to do MetaInformation\InfoNeedingToBeChanged and so on (case sensitive). Since there are a few datatypes I am not 100% all of them will work. 

     <MetaInformation>
      <Architecture>64-bit</Architecture>
      <AssetTag>Test</AssetTag>
      <Blade>test</Blade>
      <BladeDetails>Info</BladeDetails>
      <Cpu>Input here or use dropdown</Cpu>
      <CPUCoreCount>4</CPUCoreCount>
      <CustomField1Value>Ok!</CustomField1Value>
      <Domain>test</Domain>
      <Drives>2</Drives>
      <Hardware>Test info</Hardware>
      <IP>192.168.137.130</IP>
      <IsVirtualMachine>true</IsVirtualMachine>
      <Keywords>ALL Stuff PCs</Keywords>
      <LogicalCPUCount>2</LogicalCPUCount>
      <MAC>Info here</MAC>
      <MachineName>101.1001.1000</MachineName>
      <Manufacturer>Dell</Manufacturer>
      <Memory>31.75 GB</Memory>
      <ModelInformation>Test</ModelInformation>
      <Monitors>2</Monitors>
      <OS>Windows Server 2019</OS>
      <PurchaseDate>2021-06-30T13:15:01.2395177-04:00</PurchaseDate>
      <Rack>Test</Rack>
      <SerialNumber>Test</SerialNumber>
      <ServerFeatureRoles>
        <string>Domain</string>
      </ServerFeatureRoles>
      <ServiceTag>Something</ServiceTag>
      <Site>Montreal</Site>
      <SocketCount>5</SocketCount>
      <SocketType>Test</SocketType>
      <Softwares>RDM, DVLS</Softwares>
      <SupportServiceLevel>Platinum</SupportServiceLevel>
      <Vendor>Dell</Vendor>
      <Version>2021</Version>
      <VirtualMachineName>Windows Server 2019</VirtualMachineName>
      <VirtualMachineType>VMware</VirtualMachineType>
      <Warranty>2029-07-17T00:00:00-04:00</Warranty>
    </MetaInformation>



Out of curiosity have you looked at maybe doing this via PowerShell using our RDM Module ? https://help.remotedesktopmanager.com/psmodule.html

Best regards,

Eric St-Martin

avatar

Sorry for the extremely late response.

Yes, but I am not very Powershell savvy. I was attempting to have lansweeper export information to CSV, and then have RDM import it via scheduled task since from what i can see there is no direct integration/API.

I wanted the CSV headers so i could map everything correctly.

avatar
James Lafleur

Hello,

No problem, thank you for your return!

Since you are now opting for a CSV import, I recommend the link: https://help.remotedesktopmanager.com/importcsv_strategies.html. It should provide you with everything you need to adjust the format of your .csv file and import it in RDM directly using the Import Wizard.

Let us know if you have more questions on that matter!

Best regards,

James Lafleur

avatar

I will try it. Thank you!