→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎06-24-2021 09:17 PM
‎07-27-2021 09:16 PM
‎07-27-2021 06:56 PM
‎07-27-2021 05:04 PM
‎07-16-2021 08:21 PM
‎07-16-2021 06:46 PM
Select Top 1000000
tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Description,
Case
When tblAssetCustom.Model Like '%surface%'
Then 'Tablet'
Else TsysChassisTypes.ChassisName
End As [computer type],
tsysIPLocations.IPLocation As Location,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssetCustom.Serialnumber As [Serial Number],
tsysOS.OSname,
tblSystemEnclosure.Manufacturer As [PC Make],
tblAssetCustom.Model As [PC Model],
tblAssets.Processor,
tblAssets.Memory,
Stuff( ( Select ', ' + Cast(av2.DisplayName As varchar(60))
From tblAntivirus av2
Where tblAssets.AssetID = av2.AssetID
AND av2.onAccessScanningEnabled = 1 --enabled
For Xml Path('')), 1, 2, '') As [Anti-Virus/Malware],
tblDiskdrives.Volumename As [Hard Drive Name],
Cast(tblDiskdrives.Size / Power(10, 9) As numeric) As [HD Size (GB)],
tblAssetCustom.Warrantydate,
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 / 24))) + ' days ' +
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 % 24))) + ' hours ' +
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) % 3600 / 60))) + ' minutes' As uptime
From
tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSystemEnclosure On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype = tblSystemEnclosure.ChassisTypes
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Where
tblAssetCustom.Serialnumber Not Like 'VMWare%'
And tblDiskdrives.Caption = 'c:'
And tblAssetCustom.State = 1
Order By
tblAssets.AssetName
‎07-16-2021 05:45 PM
‎06-25-2021 07:22 PM
Stuff( ( Select ', ' + Cast(av2.DisplayName As varchar(60))
From tblAntivirus av2
Where tblAntivirus.AssetID = av2.AssetID
AND av2.onAccessScanningEnabled = 1 --enabled
For Xml Path('')), 1, 2, '') Antivirus,
Cast(tblDiskdrives.Size / 1024 / 1024 / 1024 As numeric) As [Hard Drive Size],
Cast(tblDiskdrives.Size / Power(2, 30) As numeric) As [HD GiB],
Cast(tblDiskdrives.Size / Power(1024, 3) As numeric) As [HD GiB (alt)],
Cast(tblDiskdrives.Size / Power(10, 9) As numeric) As [HD GB],
‎06-25-2021 02:47 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Description,
Case
When tblAssetCustom.Model Like '%surface%' Then 'Tablet'
Else tblAssetCustom.Model
End As [computer type],
tsysIPLocations.IPLocation As Location,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssetCustom.Serialnumber As [Serial Number],
tsysOS.OSname,
tblSystemEnclosure.Manufacturer As [PC Make],
tblAssetCustom.Model As [PC Model],
tblAssets.Processor,
tblAssets.Memory,
tblAntivirus.DisplayName,
tblDiskdrives.Volumename As [Hard Drive Name],
Cast(tblDiskdrives.Size / 1024 / 1024 / 1024 As numeric) As [Hard Drive Size],
tblAssetCustom.Warrantydate,
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 /
24))) + ' days ' +
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 %
24))) + ' hours ' +
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) % 3600 /
60))) + ' minutes' As uptime
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSystemEnclosure On
tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblAntivirus On tblAssets.AssetID = tblAntivirus.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Where tblAntivirus.DisplayName Not Like 'Windows%' And tblDiskdrives.Caption =
'c:' And tblAssetCustom.State = 1
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now