→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
svap
Engaged Sweeper III
please help with the following report for v5

a big list with all computers and users where software x and software y are installed
Pcname, username, fullname , software (see below), lastseen 30days, ipadress

required products:

Microsoft Project Professional 2010
Microsoft Project Standard 2010
Microsoft Visio Premium 2010
Microsoft Visio Professional 2010
Microsoft Visio Professional 2013
Microsoft Visual Studio 2005 Premier Partner Edition
Microsoft Visual Studio 2005 Professional Edition
Microsoft Visual Studio 2008 Professional Edition
Microsoft Visual Studio 2010 Premium
Microsoft Visual Studio 2010 Professional
Microsoft Visual Studio Ultimate 2012
Microsoft Visual Studio 2010 Ultimate
Microsoft Visual Studio Premium 2012

thanks!!!
p
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please try the report below for the information you are after.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Username,
tblAssets.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblAssets.Lastseen
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where (tblSoftwareUni.SoftwarePublisher Like '%microsoft vis%' And
tblAssets.Lastseen > GetDate() - 30) Or
(tblSoftwareUni.SoftwarePublisher Like '%microsoft project%' And tblAssets.Lastseen >
GetDate() - 30)
Order By tblAssets.Domain,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion

View solution in original post

2 REPLIES 2
svap
Engaged Sweeper III
manythanks!
Hemoco
Lansweeper Alumni
Please try the report below for the information you are after.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Username,
tblAssets.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblAssets.Lastseen
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where (tblSoftwareUni.SoftwarePublisher Like '%microsoft vis%' And
tblAssets.Lastseen > GetDate() - 30) Or
(tblSoftwareUni.SoftwarePublisher Like '%microsoft project%' And tblAssets.Lastseen >
GetDate() - 30)
Order By tblAssets.Domain,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion