Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-27-2013 02:32 PM
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
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
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2013 11:45 AM
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
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2013 11:50 AM
manythanks!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2013 11:45 AM
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