cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
derek_rose
Engaged Sweeper
Anyone have an example of a report I can run that will show ALL instances of Windows Server 2003 (Web, Standard, x64, etc) as well as 2008 (R2, etc)? I need to get a quick list of all serial numbers for the OS of all the servers in my environment.

So, I would like the machine name, OS "flavor" and the serial number to display on the report.

Thanks
6 REPLIES 6
derek_rose
Engaged Sweeper
Ha - so simple but yet works so well 🙂

Thanks!
Hemoco
Lansweeper Alumni
Just add the column "computername" to your report.
derek_rose
Engaged Sweeper
That report works great - is there a way I could add the machine name as a column?
Hemoco
Lansweeper Alumni
try this:

Select dbo.tblSerialnumber.Product, dbo.tblSerialnumber.ProductID,
dbo.tblSerialnumber.ProductKey, dbo.tblSerialnumber.Lastchanged,
dbo.tblSerialnumber.SerialID
From dbo.tblComputers Left Join
dbo.tblSerialnumber On (dbo.tblComputers.Computername =
dbo.tblSerialnumber.Computername) Inner Join
tblOperatingsystem On dbo.tblComputers.Computername =
tblOperatingsystem.Computername
Where (tblOperatingsystem.Caption Like '%2003%') Or
(tblOperatingsystem.Caption Like '%2008%')
derek_rose
Engaged Sweeper
Something close to this - although not getting desired results

SELECT
dbo.tblComputers.Computername,
dbo.tblSerialnumber.Product,
dbo.tblSerialnumber.ProductID,
dbo.tblSerialnumber.ProductKey,
dbo.tblSerialnumber.Lastchanged,
dbo.tblSerialnumber.SerialID
FROM
dbo.tblComputers
INNER JOIN dbo.tblSerialnumber ON (dbo.tblComputers.Computername = dbo.tblSerialnumber.Computername)
GROUP BY
dbo.tblComputers.Computername,
dbo.tblSerialnumber.Product,
dbo.tblSerialnumber.ProductID,
dbo.tblSerialnumber.ProductKey,
dbo.tblSerialnumber.Lastchanged,
dbo.tblSerialnumber.SerialID
HAVING
dbo.tblSerialnumber.Product = Like 'Microsoft Windows Server %200%'
Hemoco
Lansweeper Alumni
You can query the field "caption" in tbloperatingsystem.

where caption like '%2003%' or caption like '%2008%'