Export Asset Groups

[dmarques]

Hi,

I need to compare the Asset Groups that are in lansweeper with another table in excel.
Is there a way to export the asset groups to a csv or any other format? So I can later work with the data in excel.

Thanks

[26podcast]

I'd like to do that for the assets in the groups. Specifically I'd like to export the switches data along with all the connections to each port.

[dmarques]

Hi,

I'm referring to the asset group name, and ip ranges.

Thanks

[rader]

dmarques wrote:
Hi,

I'm referring to the asset group name, and ip ranges.

Thanks

For the Static and Dynamic Asset Groups, you can run this report and export to excel.

Select Top 1000000 tblAssetGroups.AssetGroup As AssetGroup1,
  tblAssetGroups.Builtin As Builtin1,
  tblAssetGroups.Dynamic As Dynamic1
From lansweeperdb.dbo.tblAssetGroups

For the IP scanning ranges, run this report and export.

Select Top 1000000 tsysIPLocations.IPLocation,
  tsysIPLocations.Realstart,
  tsysIPLocations.Realend
From lansweeperdb.dbo.tsysIPLocations

These will give you a shortened version of what's on the Configuration, Asset Groups page.

[rader]

Are you referring to the Asset Group names or the assets in the asset groups?