cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Tobbe
Engaged Sweeper
Hi i would like to know how to check what screen resolution all of the computers are using,
6 REPLIES 6
Hemoco
Lansweeper Alumni
This should get you started

SELECT     TOP 100 PERCENT dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblDesktopMonitor.ScreenHeight, 
dbo.tblDesktopMonitor.ScreenWidth
FROM dbo.tblComputers INNER JOIN
dbo.tblDesktopMonitor ON dbo.tblComputers.Computername = dbo.tblDesktopMonitor.Computername
ORDER BY dbo.tblComputers.Computername
taeratrin
Champion Sweeper
I hate to say it, and I hope it doesn't sound rude, but pick up a book on SQL. You're going to need it. Also get Microsoft SQL Server Management Studio Express (http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en).
Anonymous
Not applicable
taeratrin wrote:
I hate to say it, and I hope it doesn't sound rude, but pick up a book on SQL. You're going to need it. Also get Microsoft SQL Server Management Studio Express (http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en).

Or just buy Lansweeper Premium and get Report Builder. Does this sounds rude too? If you ask me, no way! - since I agree that good work should be rewarded! 😉
BullGates wrote:
taeratrin wrote:
I hate to say it, and I hope it doesn't sound rude, but pick up a book on SQL. You're going to need it. Also get Microsoft SQL Server Management Studio Express (http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en).

Or just buy Lansweeper Premium and get Report Builder. Does this sounds rude too? If you ask me, no way! - since I agree that good work should be rewarded! 😉


I´m leaning towards this solution, just have to get the boss with me on this one.
Tobbe
Engaged Sweeper
How do i do that? I have no clue on how SQL works..
Hemoco
Lansweeper Alumni
See table tblDesktopMonitor fields ScreenHeight & ScreenWidth