Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jacobsenm
Engaged Sweeper III
LANSweeper 3.2 premium.
I screwed up some standard reports. Is there an easy way to regenerate and recreate those standard reports ?

Thank you,

Menno
4 REPLIES 4
jacobsenm
Engaged Sweeper III
Thank you !
It is ok now
Hemoco
Lansweeper Alumni
All Workstations

SELECT     dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblComputersystem.Domainrole, dbo.tblComputersystem.Lastchanged
FROM dbo.tblComputersystem INNER JOIN
dbo.tblComputers ON dbo.tblComputersystem.Computername = dbo.tblComputers.Computername
WHERE (dbo.tblComputersystem.Domainrole < '2')



Windows 2000 client computers

SELECT     TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblComputers.Domain, 
dbo.tblOperatingsystem.Caption, dbo.tblOperatingsystem.Lastchanged
FROM dbo.tblOperatingsystem INNER JOIN
dbo.tblComputers ON dbo.tblOperatingsystem.Computername = dbo.tblComputers.Computername
WHERE (dbo.tblOperatingsystem.Version = '5.0.2195')
ORDER BY dbo.tblComputers.Domain

jacobsenm
Engaged Sweeper III
Reports are :
All Workstations
Windows 2000 Client Computers


Thank you
Hemoco
Lansweeper Alumni
Please give me the names of the reports and I'll give your the standard SQL code which you can use.

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now