Solved

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

Posted on 2010-09-14
10
821 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

 
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
 

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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

726 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