→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
E-Dub
Engaged Sweeper
I just installed Lansweeper. After about 45min and a few permission issues, it's running fine and the web console is running fine.

The question I have is what would be the best way to view all the machines running a specific OS ?
Is this option available on the Web Console or do I have to query the SQL table (which table is it?).



Thanks for any support.

e.

3 REPLIES 3
Hemoco
Lansweeper Alumni
thanks,

You can help by promoting Runscanner, I need more testers and online analysis.
When it's done, I connect the search to the lansweeper interface.

Meanwhile I'm fixing some lansweeper memory leak issues with clients which have (wrong permissions in registry/wmi, ...)
And I'm creating some better error reporting.
E-Dub
Engaged Sweeper
Thanks. I did figure it all out with Access/MSQuery. I'm going to incorporate this info into a VB Admin utility and our desktop remote control apps. Good job on the whole thing.
Hemoco
Lansweeper Alumni
easiest is to create a query:

SELECT dbo.tblComputers.Computername, dbo.tblOperatingsystem.Caption, dbo.tblOperatingsystem.CSDVersion, dbo.tblOperatingsystem.OSLanguage FROM dbo.tblComputers LEFT OUTER JOIN dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername