Solved

SCCM 2012 Query help

Posted on 2014-01-21
11
333 Views
Last Modified: 2014-05-07
Hi Experts,

I am trying to get a query to work in SCCM 2012, but can't get it right.

I want to list all computers  in a collection with Java that is less than 7.0.510, but not 7.0.510. So if a computer has 7.0.510, it won't be listed but all below that version will be.
One collection for x64 and one x86.

The strategy of just using the Installed Applications and Display name like %Java% and version less than 7.0.510, but not 7.0.510 failed.

The plan was to shoot a deployment towards this collection with version 7.0.510 and see the number of computers drop in numbers.

anyone know how to get it right?
0
Comment
Question by:Madjax
[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
  • 6
  • 3
  • 2
11 Comments
 
LVL 24

Expert Comment

by:Nagendra Pratap Singh
ID: 39802426
Where is the current query?
0
 
LVL 25

Expert Comment

by:Lionel MM
ID: 39803077
There is a similar question already here at EE, you would just have to tweak the version
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_26928160.html
0
 
LVL 10

Author Comment

by:Madjax
ID: 39811229
I will try it when i am back at work.
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 10

Author Comment

by:Madjax
ID: 39820138
I can't get it to work with that link (even when trying to mod it). Problem is when people write such queries is that it only fits them most of the time.

It's so frustrating that MS doesn't allow many AND statements in same query. Does one need to be SQL Legend to fix a simple SCCM query?
0
 
LVL 24

Expert Comment

by:Nagendra Pratap Singh
ID: 39820291
SCCM mostly works. The tools provided in it are fit for 99 % of the users.

BTW you have still not listed the exact query that is not working.
0
 
LVL 10

Author Comment

by:Madjax
ID: 39823365
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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Java 7%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version < "7.0.510" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version != "7.0.510"

Open in new window

0
 
LVL 24

Expert Comment

by:Nagendra Pratap Singh
ID: 39823631
Does this much work?



    My Account
    Log Out

    Help
    About Us

    Hello,  Nagendra Pratap Singh

798

    Ask
    Answer
    Topics
        Microsoft
        Apple
        Digital Living
        Hardware
        Software
        Operating Systems
        Storage
        Database
        Security
        Programming
        Web Development
        Networking
        Virus & Spyware
        Copy Review
        Community Support
        Browse All
    Articles
    Cloud Class New
    BugFinder
        Start Testing
        Submit a Project
        How it Works
        Points for Experts
    More
        Drackula DCIM
        Writing Help
        Job Board
        Business Accounts
        EE Blog

Experts Exchange Logo

or Go to Advanced Search
Experts Exchange > OS > Microsoft OS > MS Server OS > SCCM 2012 Query help
Question

    Ask A New Question

SCCM 2012 Query help
Asked by: Madjax
Hi Experts,

I am trying to get a query to work in SCCM 2012, but can't get it right.

I want to list all computers  in a collection with Java that is less than 7.0.510, but not 7.0.510. So if a computer has 7.0.510, it won't be listed but all below that version will be.
One collection for x64 and one x86.

The strategy of just using the Installed Applications and Display name like %Java% and version less than 7.0.510, but not 7.0.510 failed.

The plan was to shoot a deployment towards this collection with version 7.0.510 and see the number of computers drop in numbers.

anyone know how to get it right?

    2014-01-22 at 13:08:36ID28344844
Tags
    sccm 2012
    ,
    configuration manager
    ,
    query
    ,
    deployment
Topics
    Microsoft Server
    ,
    Microsoft Operating Systems
Participating Experts
    2
Points
    500
Comments
    6

Request Attention
Answers
 

Your Comment

by: Nagendra Pratap SinghPosted on 2014-01-23 at 14:39:40ID: 39802426
Rank: Sage
Where is the current query?
 

Expert Comment

by: lionelmmPosted on 2014-01-23 at 19:44:49ID: 39803077
Rank: Wizard
There is a similar question already here at EE, you would just have to tweak the version
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_26928160.html
 

Author Comment

by: MadjaxPosted on 2014-01-27 at 12:55:15ID: 39811229
I will try it when i am back at work.
 

Author Comment

by: MadjaxPosted on 2014-01-30 at 13:12:53ID: 39820138
I can't get it to work with that link (even when trying to mod it). Problem is when people write such queries is that it only fits them most of the time.

It's so frustrating that MS doesn't allow many AND statements in same query. Does one need to be SQL Legend to fix a simple SCCM query?
 

Your Comment

by: Nagendra Pratap SinghPosted on 2014-01-30 at 15:17:51ID: 39820291
Rank: Sage
SCCM mostly works. The tools provided in it are fit for 99 % of the users.

BTW you have still not listed the exact query that is not working.
 

Author Comment



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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Java 7%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version < "7.0.510"
0
 
LVL 25

Expert Comment

by:Lionel MM
ID: 39823866
Nagendra Pratap Singh
What was this--it looks like you copied and pasted the EE page you were on--this page.
0
 
LVL 10

Author Comment

by:Madjax
ID: 39829024
The query that I posted lists even the ones that have version 7.0.510 which I don't want. So that's the issue.
The "NOT equal to"-step doesn't work.
0
 
LVL 10

Accepted Solution

by:
Madjax earned 0 total points
ID: 39872659
anyone?
0
 
LVL 10

Author Closing Comment

by:Madjax
ID: 40046612
It's abandoned and I got no solution to it.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration of the Data Protection Manager product. Note that this demonstration was prepared on the basis of Windows OS is 2008 R2 and DPM 2010. DATA PROTECTI…
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…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

707 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