Like Windows Server %

[derek_rose]

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

[derek_rose]

Ha - so simple but yet works so well 🙂

Thanks!

[Hemoco]

Just add the column "computername" to your report.

[derek_rose]

That report works great - is there a way I could add the machine name as a column?

[Hemoco]

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]

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]

You can query the field "caption" in tbloperatingsystem.

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