Hi all
I'm having trouble combining 3 reports into 1.
In short i'm looking for a report to give all asset spec info.
So to include - hostname, user, Make, model, CPU, RAM, graphics card, HDD total size, Serial number, Purchase date, Warranty expiration
I have 3 reports i run seperately. I've tried and failed to combine them. I dont need the linux info, this is a Windows environment
Please can someone assist and improve if they see fit!
🙂Here are my 3 reports
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblADusers.Displayname,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblAssetCustom.PurchaseDate As [Purchase Date],
tblAssetCustom.Warrantydate As [Warranty Expiration],
tblAssets.Processor,
tblAssets.Memory,
tblAssets.IPAddress,
tsysOS.Image As icon
From tblAssets
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Left Join tblADusers On tblADusers.Userdomain = tblAssets.Userdomain
And tblADusers.Username = tblAssets.Username
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen As [last scan],
Sum(Cast(Cast(tblDiskdrives.Size As BigInt) / 1024 / 1024 / 1024 As Numeric))
As [Total size (GB)],
Sum(Cast(Cast(tblDiskdrives.Freespace As BigInt) / 1024 / 1024 /
1024 As Numeric)) As [Free in GB]
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Group By tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen
Order By tblAssets.AssetName
Select Top 10000 tblAssets.AssetID,
tblAssets.AssetName,
tblVideoController.Caption As [Windows Graphics Card],
tblLinuxGraphicsCards.Name As [Linux Graphics Card]
From tblAssets
Left Join tblVideoController On tblAssets.AssetID = tblVideoController.AssetID
Left Join tblLinuxGraphicsCards
On tblAssets.AssetID = tblLinuxGraphicsCards.AssetID