SMS Query to determine MDAC version

[owenhawk]

Can an SMS query be configured to report the version of MDAC on a device? My initial thought is no, since I can not find any hits on this subject. I know about the MS MDAC component checker program which I guess I could push down to a device and run and then analyze the file export, but first I wanted to see if there is a way to do this with a simple SMS query. Thanx for any information.

 

[GSC]

Hi,

Here is the query information from a collection that I created earlier today.
In this one I'm looking for MDAC 2.5 SP3 on Win 2000 SP4 systems.

Hope this helps you.

Cheers,
GSC


select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System inner join SMS_G_System_PATCHSTATE on SMS_G_System_PATCHSTATE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PATCHSTATE.Product = "MDAC 2.5 SP3" and (SMS_R_System.OperatingSystemNameandVersion = "Microsoft Windows NT Server 5.0" and SMS_G_System_OPERATING_SYSTEM.CSDVersion = "Service Pack 4")

 

[ncotton]

I'll give you that one GSC...Was just about to post. Ach well. If you don't care about the filtering of the OS versions you could use something like this (hack from GSC, not tested)

//ORIGINAL QUERY GSAC@Tek.Tip.com
//EDITED : NCotton
select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System inner join SMS_G_System_PATCHSTATE on SMS_G_System_PATCHSTATE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PATCHSTATE.Product like "MDAC"

Neil J Cotton
njc Information Systems
Systems Consultant

 

[owenhawk]

Thank you both for your suggestions, unfortunately I don't think MDAC is tracked by SMS as a product. I don't see anything with MDAC listed in any of our SMS reports. I think that is why MS provides the Component Checker because you have evaluate many dlls to know what true version of MDAC you have. If you are seeing a product call MDAC from SMS, maybe our's is missing something, I would like to know how. Thank you again.

 

[ncotton]

Im at home now, i will check out the database in the morning.

Neil J Cotton
njc Information Systems
Systems Consultant

 

[ncotton]

I'll have a look when i get a minute, but if there is anywhere in WMI that this is stored, then you could just edit the def.mof and return it on HINV and query that. Not looked for this value before, but it should be in there.

Neil J Cotton
njc Information Systems
Systems Consultant