Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-27-2011 10:29 PM
I got mixed up creating a new report in the builder and managed to save over the OS: Not Latest Service Pack Wndows 7 stock report. Can someone provide me the default query for that?
Also is there an easy way to recover the stock reports?
Also is there an easy way to recover the stock reports?
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
‎04-13-2015 01:50 PM
Just an FYI for everyone: all built-in reports can now be found in the Report Center.
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-13-2015 01:50 PM
Just an FYI for everyone: all built-in reports can now be found in the Report Center.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-28-2011 12:55 PM
This is the standard code for the report "OS: Not latest Service Pack Windows 7":
If you ever accidentally overwrite one of the built-in reports, please contact us at support@lansweeper.com
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description, tblOperatingsystem.ServicePackMajorVersion As [Current SP], tblComputers.Lastseen, Web40OSName.Compimage As icon From tblOperatingsystem Inner Join tblComputers On tblOperatingsystem.Computername = tblComputers.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Where Web40OSName.OSname = 'Win 7' And tblOperatingsystem.ServicePackMajorVersion <> '1' Order By dbo.tblComputers.Computer
If you ever accidentally overwrite one of the built-in reports, please contact us at support@lansweeper.com
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-27-2011 11:28 PM
I copied and modified the OS: Not latest Service Pack Win2008 R2 and changed the Web40OSName to 'Win 7' and all is well again.
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description, tblOperatingsystem.ServicePackMajorVersion As [Current SP], tblComputers.Lastseen, Web40OSName.Compimage As icon From tblOperatingsystem Inner Join tblComputers On tblOperatingsystem.Computername = tblComputers.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Where Web40OSName.OSname = 'Win 7' And tblOperatingsystem.ServicePackMajorVersion <> '1' Order By dbo.tblComputers.Computer
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description, tblOperatingsystem.ServicePackMajorVersion As [Current SP], tblComputers.Lastseen, Web40OSName.Compimage As icon From tblOperatingsystem Inner Join tblComputers On tblOperatingsystem.Computername = tblComputers.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Where Web40OSName.OSname = 'Win 7' And tblOperatingsystem.ServicePackMajorVersion <> '1' Order By dbo.tblComputers.Computer
