04-24-2013 06:16 PM
Solved! Go to Solution.
04-30-2013 01:29 PM
chaley wrote:
However I keep getting errors that some of the tables dont exist such as tblComputers. I tried to rename it, but ran into other errors.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
TsysChassisTypes.ChassisName,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysIPLocations.IPLocation,
tsysOS.OSname,
tblOperatingsystem.Caption As FullOSname,
tblAssets.SP,
tblOperatingsystem.InstallDate,
tblOperatingsystem.SerialNumber,
tblAssets.Username,
tblAssets.Userdomain,
tblAssetCustom.Serialnumber As AssetTag,
tblAssets.Memory,
tblAssets.Processor,
tblNetwork.Description As NIC,
tblNetwork.IPAddress,
tblNetwork.MACaddress,
tblDiskdrives.Caption As [Disk],
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Where Ceiling(tblDiskdrives.Size / 1024 / 1024) <> 0 And tblAssetCustom.State =
1 And tblNetwork.IPEnabled = 1 And tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
tblAssets.AssetName,
[Disk]
chaley wrote:
I would also like to add installed drives such as CD's and Floppy's if possible.
05-08-2013 10:07 PM
05-02-2013 04:31 PM
04-30-2013 01:29 PM
chaley wrote:
However I keep getting errors that some of the tables dont exist such as tblComputers. I tried to rename it, but ran into other errors.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
TsysChassisTypes.ChassisName,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysIPLocations.IPLocation,
tsysOS.OSname,
tblOperatingsystem.Caption As FullOSname,
tblAssets.SP,
tblOperatingsystem.InstallDate,
tblOperatingsystem.SerialNumber,
tblAssets.Username,
tblAssets.Userdomain,
tblAssetCustom.Serialnumber As AssetTag,
tblAssets.Memory,
tblAssets.Processor,
tblNetwork.Description As NIC,
tblNetwork.IPAddress,
tblNetwork.MACaddress,
tblDiskdrives.Caption As [Disk],
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Where Ceiling(tblDiskdrives.Size / 1024 / 1024) <> 0 And tblAssetCustom.State =
1 And tblNetwork.IPEnabled = 1 And tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
tblAssets.AssetName,
[Disk]
chaley wrote:
I would also like to add installed drives such as CD's and Floppy's if possible.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now