Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-20-2014 12:16 PM
Hi All,
I have the below SQL script which gives me all I need. The only thing it does not report back are VM host servers, Can anyone point me in the right direction?
Select Top 1000000 tblAssets.FQDN,
tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblDiskdrives.Caption As [Drive Letter],
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
Ceiling((tblDiskdrives.Size / 1024 / 1024) - (tblDiskdrives.Freespace / 1024 /
1024)) As UsedMB,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblAssets.NrProcessors,
tblAssets.Processor,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tsysOS.OSname,
tblAssets.SP,
tsysAssetTypes.AssetTypename
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where (tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1 And
tblDiskdrives.DriveType = 3) Or
(tsysAssetTypes.AssetTypename Like '%vmware%' And
tsysAssetTypes.AssetTypename Like '%vmware%' And tblAssetCustom.State = 1)
Order By tblAssets.AssetName,
[Drive Letter]
I have the below SQL script which gives me all I need. The only thing it does not report back are VM host servers, Can anyone point me in the right direction?
Select Top 1000000 tblAssets.FQDN,
tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblDiskdrives.Caption As [Drive Letter],
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
Ceiling((tblDiskdrives.Size / 1024 / 1024) - (tblDiskdrives.Freespace / 1024 /
1024)) As UsedMB,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblAssets.NrProcessors,
tblAssets.Processor,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tsysOS.OSname,
tblAssets.SP,
tsysAssetTypes.AssetTypename
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where (tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1 And
tblDiskdrives.DriveType = 3) Or
(tsysAssetTypes.AssetTypename Like '%vmware%' And
tsysAssetTypes.AssetTypename Like '%vmware%' And tblAssetCustom.State = 1)
Order By tblAssets.AssetName,
[Drive Letter]
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-21-2014 12:59 AM
I don't have any VMWare servers, but I do have some workstations. Maybe you can identify them the same way.
Where actual field contents are:
I show some Microsoft VM servers on my network, too.
-- belt & suspenders: check for either field to match
tblAssetCustom.Manufacturer Like 'VMWare%'
OR tblAssetCustom.Model Like 'VMWare%'
Where actual field contents are:
Manufacturer: VMware, Inc.
Model.......: VMware Virtual Platform
I show some Microsoft VM servers on my network, too.
Manufacturer: Microsoft Corporation
Model.......: Virtual Machine
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-21-2014 12:59 AM
I don't have any VMWare servers, but I do have some workstations. Maybe you can identify them the same way.
Where actual field contents are:
I show some Microsoft VM servers on my network, too.
-- belt & suspenders: check for either field to match
tblAssetCustom.Manufacturer Like 'VMWare%'
OR tblAssetCustom.Model Like 'VMWare%'
Where actual field contents are:
Manufacturer: VMware, Inc.
Model.......: VMware Virtual Platform
I show some Microsoft VM servers on my network, too.
Manufacturer: Microsoft Corporation
Model.......: Virtual Machine