Screen sizes

[Tobbe]

Hi i would like to know how to check what screen resolution all of the computers are using,

[Hemoco]

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]

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]

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! 😉

[Tobbe]

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]

How do i do that? I have no clue on how SQL works..

[Hemoco]

See table tblDesktopMonitor fields ScreenHeight & ScreenWidth