XEN virtual machines in Phisical servers report

[talomer40]

Hi,

I have a report with all my physical servers, somehow i see there XEN virtual machines, anyone with the same issue>?

[Hemoco · Accepted solution]

Try:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tblAssetCustom.Manufacturer
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Left Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where (tsysIPLocations.IPLocation Like '%lab%' And tblAssetCustom.State = 1 And
tblAssetCustom.Model Not Like '%virtual%' And tblAssets.Assettype = -1) Or
(tsysAssetTypes.AssetTypename = 'linux' And tsysIPLocations.IPLocation Like
'%lab%' And tblAssetCustom.Manufacturer Not Like '%vmware%' And
tblAssetCustom.State = 1 And tblAssetCustom.Model Not Like '%virtual%') Or
(tsysAssetTypes.AssetTypename = 'xen server' And
tsysIPLocations.IPLocation Like '%lab%' And tblAssetCustom.Manufacturer Not Like '%vmware%' And tblAssetCustom.State = 1 And tblAssetCustom.Model Not Like '%virtual%')
Order By tblAssets.IPAddress

[talomer40]

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tblAssetCustom.Manufacturer
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Left Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where (tsysIPLocations.IPLocation Like '%lab%' And tblAssetCustom.State = 1 And
tblAssetCustom.Model Not Like '%virtual%' And tblAssets.Assettype = -1) Or
(tsysAssetTypes.AssetTypename = 'linux' And tsysIPLocations.IPLocation Like
'%lab%' And tblAssetCustom.Manufacturer Not Like '%vmware%' And
tblAssetCustom.State = 1 And tblAssetCustom.Model Not Like '%virtual%') Or
(tsysAssetTypes.AssetTypename = 'xen server' And
tsysIPLocations.IPLocation Like '%lab%' And tblAssetCustom.State = 1)
Order By tblAssets.IPAddress

[Hemoco]

Please post the SQL query you are running.