?
Solved

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

Posted on 2010-09-14
10
Medium Priority
?
826 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 2000 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
How to Create Failover DNS Record Sets in Route 53

Route 53 has the ability to easily configure DNS record sets specifically for failover scenarios. These failover record sets can be configured to failover to full-blown deployments in other regions or to a static HTML page that informs your customers of the issue.

 
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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

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…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

765 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