Current position:Home > sccm 2012 query rule

sccm 2012 query rule

Advertisement

IN NEED OF A SCCM 2012 QUERY THAT SHOWS LAST TIME SOFTWARE WAS USED OR OPENED

2015-10-11

Hello I am in need of an SCCM 2012 query that shows PCs that have Visio , Adobe Professional and Visual Studio and the last time each was used or opened. I have the query below which give me the PC name and the product. Any assistance will be very he

SCCM 2012 QUERY THAT SHOWS SOFTWARE INSTALLED AND LAST TIME IT WAS USED OR OPENED

2015-10-11

Hello I am in need of an SCCM 2012 query that shows PCs that have Visio , Adobe Professional and Visual Studio and the last time each was used or opened. I have the query below which give me the PC name and the product. Any assistance will be very he

SCCM 2012 Query report for specific software installed.

2015-10-11

I have Reporting point installed and it seems to be working as I was able to run OS reports. Here's what I would like to do. 1. I need a query/report to show us all the machines that do not have Microsoft Forefront Endpoint Protection installed. 2. I

How to inner join attribuet from user with system resource on sccm 2012 query

-0001-11-30

Hi , I am using SCCM 2012. Trying to create a WQL query to get list of computers with department name and netbios names,etc. these are in USER  and SYSTEM RESOURCE  object type seperately. The query wizard doesn't allow me to choose sytem resource an

Sccm 2012 query self encrypting drives

-0001-11-30

I have SCCM 2012 SP1,   does anyone know of a way to query a collection, for self encrypting drives?   All I really need  to know is; of my "laptop" collection,  which ones have Self Encrypting Drives.For BitLocker you can use the following: htt

SCCM 2012 - Query

-0001-11-30

Hi, I have primary SCCM 2012 SP1, SCCM database server and standalone reporting SQL server separately. 1. I am trying to enable reporting service role in which it is detecting the primary database automatically. When i enter standalone reporting SQL

SCCM 2012 Query to find units with IPv6 Enabled?

-0001-11-30

We've found a need to locate computers that may have IPv6 enabled for audit purposes, and then we'll disable them at a later date. Has anyone been able to create a successful query in SCCM 2012 to get that information?  I found this but it spit back

SCCM 2012 - Query Local Admin Users

-0001-11-30

Hi Guys, I´m trying to get all users that are local admins of my network using sccm12. How it´s possible? Thank you.Hi, We can use the following query as follows SELECT DISTINCT SYS.Netbios_Name0, SYS.User_Name0, LocalAdminMembers.TimeStamp, LocalAdm

SCCM 2012 Query collection problem

-0001-11-30

Hi! I have problem with query based collections. I want to create collection where is computers with db2 client and sql express installed. Query is like that: select *  from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_AD

SCCM 2012 Query to list all office 2010 x86 architectures systems

-0001-11-30

Hi, I am trying to find all the x86 versions of office 2010 in one query to install a x86 application to and all the x64 versions of office 2010 in another query to install an x64 application to, i got the x64 to work its just that my x86 query picks

SCCM 2012 Query to populate collection with users of 3 similar characters

-0001-11-30

Hi,  I'm trying to create a query to populate a collection for my QA users. I have 5 QA users and about 10,000 users on the domain. Those users are inside a "TQA" group so I just need to know a way to create a dynamic collection that will be pop

SCCM 2012 R2 Empty Query in Collection

-0001-11-30

Now, I just discovered yesterday where I created Collection with query but resulted NONE. I know there's no problem with the query itself because I created the same one within the query itself and it give me the result. Here's another problem with my

Query for collection is not function on SCCM 2012 R2

-0001-11-30

Hi, I have a System Center 2012 R2 Config Manager as single management point. The SCCM is already have Endpoint Protection Point role installed. Then I need to create a new collection that contain all SCEP clients, to as deployment target of a rule a

SCCM Device Query for SCEP 2012 SP1 CU5

-0001-11-30

Dear all, I want to create a device query rule for SCEP client agent installed machines , SCCM version we are using SCCM 2012 SP1 CU5. If any one has the query , please let me know. Thanks, Sengottuvel Mselect distinct SMS_R_System.Name from SMS_R_Sy

SCCM 2012 R2 CU2 Can't Edit WMI Query Code in Report Builder

2015-10-11

I first posted this in the SCCM but the issue is not solved so I thought I'd try here in the SQL Reporting forum. Original thread here: http://social.technet.microsoft.com/Forums/en-US/b0a6ca3d-7471-4b49-8447-7403a65c2ec0/sccm-2012-r2-cu2-cant-edit-w

What are the Query criterion property attributes to search for KB's in SCCM 2012

2015-10-11

A client is ask what servers might have a particular hotfix(ex: KB2798040) installed. The Hotifx is not in our WSUS catalog because it is not a critical security patch so it is not downloaded. What is the SCCM 2012 R2 Query criterion property attribu

Create a query in SCCM 2012 R2 for NIC Driver Version

-0001-11-30

Hello,     Is there a way to create a query for the specific NIC driver versions with SCCM 2012 R2? For example I can do this and other descriptors for video i.e., select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_R_System.HardwareID, SMS

Need to make collection Query statement by sccm 2012 sp1 for Count of Licenses by License Status

-0001-11-30

I want to make collection Query statement by sccm 2012 sp1 for all windows activated and all non-activated windows. Ahmed SherifHave a look at the Software Licensing Product attribute classes when creating a Query - remember to choose System Ressourc

Query to get the Deployment Status of an application - SCCM 2012

-0001-11-30

Hi, Do we have any query/report to get the detailed status report & machine name, user name of a deployment in sccm 2012 as in sccm 2007, instead of clicking on each deployment status to find the machine names and status details? Regards, Mike.Hi, Yo

OSD: SCCM 2012 collection which should exclude Windows 7 clients (query not working fine)

-0001-11-30

Hi, We have an SCCM 2012 collection to which we deploy Windows 7. Vista clients get a SCCM 2012 client in SCCM 2007 and once they have it, they get a Windows 7 deployment. The group is populated by an AD query and that works fine. However, when we tr