‎04-29-2013 06:15 PM
Solved! Go to Solution.
‎05-03-2013 07:15 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
TsysChassisTypes.ChassisName,
tsysOS.OSname,
tblAssets.SP,
tblAssetCustom.Serialnumber As AssetTag,
tblAssets.Lastseen,
tblAssets.IPAddress,
tblSoftwareUni.softwareName As OfficeVersion,
Round((Cast((DateDiff(mm, tblBIOS.ReleaseDate, GetDate())) As float) / 12),
2) As AgeInYears
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Where tblSoftwareUni.softwareName Like 'Microsoft%office%20%'
Order By AgeInYears Desc
‎05-08-2013 10:13 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
TsysChassisTypes.ChassisName,
tsysOS.OSname,
tblAssets.SP,
tblAssetCustom.Serialnumber As AssetTag,
tblAssets.Lastseen,
tblAssets.IPAddress,
Round((Cast((DateDiff(mm, tblBIOS.ReleaseDate, GetDate())) As float) / 12),
2) As AgeInYears
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Order By AgeInYears Desc
‎05-08-2013 10:04 PM
‎05-03-2013 08:39 PM
‎05-08-2013 09:47 PM
Hobbs13 wrote:
Is there anyway to eliminate the duplicate rows by listing multiple office products on a single line?
‎05-03-2013 07:15 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
TsysChassisTypes.ChassisName,
tsysOS.OSname,
tblAssets.SP,
tblAssetCustom.Serialnumber As AssetTag,
tblAssets.Lastseen,
tblAssets.IPAddress,
tblSoftwareUni.softwareName As OfficeVersion,
Round((Cast((DateDiff(mm, tblBIOS.ReleaseDate, GetDate())) As float) / 12),
2) As AgeInYears
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Where tblSoftwareUni.softwareName Like 'Microsoft%office%20%'
Order By AgeInYears Desc
‎04-30-2013 06:13 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now