Mass editing/importing asset relationships

[bimbam]

Cursory apologies in advance if this has been asked, yes I searched, yes I found nothing relevant 😞
Also apologies if this is in the wrong section, first time poster and all that ^^

I am hoping to find a way to link Software Assets to Hardware Assets en masse. I will explain what I am trying to achieve:

I have manually created a software asset with a custom field for 'Total licenses', so for example 'Microsoft Office 2007' has a custom field 'Total licenses : 500'.

I want to then form a relationship from this one asset, to all the assets that 'should' have it installed, based on a list of host names I already posses. From this I can then generate a report that scans my domain and compares machines that have the software installed and machines that should have the software installed.

As far as I can tell, the front-end only allows me to at best manually search through a list of Hostname's, ticking the ones I want to then add to this software asset. This is not ideal when there may be 100/1000s of assets.

Is it possible to import a CSV file that simple has a list of host names with a list of software assets to form a relationship with? Presumably this is going to require some SQL wizardry?

Thanks in advance for any help/advice given

[Daniel_B · Accepted solution]

For the moment importing asset relations or asset group memberships is not supported. We may add this feature at a later time. If possible, you could create a custom report which lists the hostnames you would like to scan, like the following example report. You will be able to perform a rescan on the computers listed in this report and even directly see which version of MS Office they have installed.
Alternatively use the license compliance module for this purpose. Create a license for Office 2007, be sure to add only Office 2007 installations under tab Software, create an order with a license count of 500 under tab Orders and view the license compliance report.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.Lastseen,
  tOffice.softwareName,
  tOffice.softwareVersion
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join (Select tblSoftware.AssetID,
    tblSoftwareUni.softwareName,
    tblSoftware.softwareVersion
  From tblSoftware
    Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Where tblSoftwareUni.softwareName Like 'Microsoft Office % 20%') tOffice
    On tOffice.AssetID = tblAssets.AssetID
Where tblAssets.AssetName In ('LAN-001', 'LAN-002', 'LAN-003', 'LAN-004',
  'LAN-005') And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  tOffice.softwareName