myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


.NET framework versions

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> .NET framework versions Page: [1]
Login
Message << Older Topic   Newer Topic >>
.NET framework versions - 8/22/2005 4:55:48 PM   
ssumgirl

 

Posts: 186
Score: 0
Joined: 11/24/2004
Status: offline
Can someone tell me how I can determine the .NET framework versions on my client machines? Is there an exe or dll I can check the version of in SMS inventory - or something?
Post #: 1
RE: .NET framework versions - 8/22/2005 5:37:11 PM   
mcarriere893


Posts: 3621
Score: 300
Joined: 4/12/2002
From: Manitoba, Canada
Status: offline
Couple o simple ones to get you started:

SELECT DISTINCT v_R_System.Name0, v_SoftwareProduct.ProductName, v_SoftwareProduct.ProductVersion
FROM v_SoftwareInventory INNER JOIN
v_SoftwareProduct ON v_SoftwareInventory.ProductId = v_SoftwareProduct.ProductID INNER JOIN
v_R_System ON v_SoftwareInventory.ClientId = v_R_System.ResourceID
WHERE (v_SoftwareProduct.ProductName = ' Microsoft (R) .NET Framework' )
ORDER BY v_R_System.Name0, v_SoftwareProduct.ProductVersion

SELECT DISTINCT v_R_System.Name0, v_GS_ADD_REMOVE_PROGRAMS.DisplayName0, v_GS_ADD_REMOVE_PROGRAMS.Version0
FROM v_GS_ADD_REMOVE_PROGRAMS INNER JOIN
v_R_System ON v_GS_ADD_REMOVE_PROGRAMS.ResourceID = v_R_System.ResourceID
WHERE (v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 IN (' Microsoft .NET Framework (English)' , ' Microsoft .NET Framework 1.1' , ' Microsoft .NET Framework 2.0' , ' Microsoft .NET Framework 2.0 Beta' ,
' Microsoft .NET Framework 2.0 Beta 2' ))
ORDER BY v_GS_ADD_REMOVE_PROGRAMS.DisplayName0

_____________________________

Mark Carriere
Microsoft MVP-SMS
www.SMSUG.ca

(in reply to ssumgirl)
Post #: 2
RE: .NET framework versions - 8/23/2005 11:26:22 AM   
ssumgirl

 

Posts: 186
Score: 0
Joined: 11/24/2004
Status: offline
Thanks Mark! Would you happent to know when/how .NET framework is bundled these days? Does it come with XP or some version of IE or do you have to install it seperate?

(in reply to ssumgirl)
Post #: 3
RE: .NET framework versions - 8/23/2005 11:35:29 AM   
mcarriere893


Posts: 3621
Score: 300
Joined: 4/12/2002
From: Manitoba, Canada
Status: offline
Yikes, what doesn' t try to install it these days. We have a ton of developers here who try to bundle it with almost all of their apps. Of course they never have the right version. We' ve upped to XP SP2, so are covered.
As far as OS:
Windows XP SP2 includes MDAC 2.8 SP1
Windows 2003 SP1 includes MDAC 2.8 SP2


_____________________________

Mark Carriere
Microsoft MVP-SMS
www.SMSUG.ca

(in reply to ssumgirl)
Post #: 4
RE: .NET framework versions - 7/31/2008 10:55:00 AM   
ttower336

 

Posts: 3
Score: 0
Joined: 7/29/2008
Status: offline
I get an error "WBEM_E_INVALID_QUERY" when I run these queries.  Any ideas???

(in reply to mcarriere893)
Post #: 5
RE: .NET framework versions - 7/31/2008 11:32:15 AM   
jnelson993


Posts: 959
Score: 132
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline
These are SQL queries for web reports, not WQL queries for SMS Queries/Collection Queries.

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to ttower336)
Post #: 6
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> .NET framework versions Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.531