Solved

Report for SCCM with SQL Server machines and version of sql installed

Posted on 2010-09-14
10
809 Views
Last Modified: 2013-11-21
I have this SQL statement

SELECT     v_GS_SYSTEM.Name0, v_GS_SYSTEM.Domain0, v_GS_SYSTEM.SystemRole0, v_GS_SYSTEM.SystemType0
FROM         v_GS_SYSTEM INNER JOIN
                      v_GS_SERVICE ON v_GS_SYSTEM.ResourceID = v_GS_SERVICE.ResourceID
WHERE     (v_GS_SERVICE.DisplayName0 = 'SQL Server"')

To get a report in which besides sql 2005, I say the sql 2000 express on the domain that anyone could guide me?

Thanks
0
Comment
Question by:ggarate
  • 5
  • 3
10 Comments
 
LVL 6

Expert Comment

by:TarekIsmail
ID: 33698273
HI ,
could you please check this

SELECT     v_GS_SYSTEM.Name0, v_GS_SYSTEM.SystemRole0, v_GS_SYSTEM.SystemType0, v_GS_SYSTEM.Domain0, v_HS_INSTALLED_SOFTWARE.ARPDisplayName0
                     
FROM         v_HS_INSTALLED_SOFTWARE INNER JOIN
                      v_GS_SYSTEM ON v_HS_INSTALLED_SOFTWARE.ResourceID = v_GS_SYSTEM.ResourceID
 where ARPDisplayName0 like '%SQL%'  


please update me if you need more things

Good Luck!
Tarek Ismail
0
 
LVL 6

Accepted Solution

by:
TarekIsmail earned 500 total points
ID: 33698287
to get domain controllers running any SQL
=================================

SELECT     v_GS_SYSTEM.Name0, v_GS_SYSTEM.SystemRole0, v_GS_SYSTEM.SystemType0, v_GS_SYSTEM.Domain0, v_HS_INSTALLED_SOFTWARE.ARPDisplayName0
                     
FROM         v_HS_INSTALLED_SOFTWARE INNER JOIN
                      v_GS_SYSTEM ON v_HS_INSTALLED_SOFTWARE.ResourceID = v_GS_SYSTEM.ResourceID
 where ARPDisplayName0 like '%SQL%'
 and SystemRole0 ='domain'      
0
 
LVL 6

Expert Comment

by:TarekIsmail
ID: 33720201
i hope my answer help you !
please let me know if you need more help
0
 
LVL 6

Expert Comment

by:TarekIsmail
ID: 33732171
Hi ggarate,

it seems you ask to close the question , and this will take 4 days
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:ggarate
ID: 33745708
Gives the correct result, but I need to filter only by SQL Server, either version 2000, 2005 or 2008

Regards
0
 
LVL 6

Expert Comment

by:TarekIsmail
ID: 33746408
can you open it in new question ?
as we already finish this one , right?
0
 

Author Comment

by:ggarate
ID: 33746423
Correct, but how name the question? Thanks
0
 

Author Closing Comment

by:ggarate
ID: 33746434
Thanks
0

Featured Post

The curse of the end user strikes again      

You’ve updated all your end user’s email signatures. Hooray! But guess what? They’re playing around with the HTML, adding stupid taglines and ruining the imagery. Find out how you can save your signatures from end users today.

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now