Search the Community
Showing results for tags 'Query'.
-
I am trying to build a collection based on the Last Online time (within an arbitrary number of days). I know typically this is done using the Heartbeat, ClientActivity, or Hardware scan property. but I would like to see all machines, to identify which machines may not have the client installed....
-
I'm using the following report and checking against all systems for %iTunes%. My report comes back with around 35 systems. However, I've created a collection for iTunes, and it is only showing 9 systems. The query I am using for the collection is the following. select SMS_R_SYSTEM....
-
I have a requirement to create 2 collections from AD groups and return only the users/machines that are in both. I have tried something like the following:- SELECT ... WHERE ResourceID IN (SELECT ResourceID FROM SMS_R_User where SMS_R_User.SecurityGroupName = <GroupA>) A... -
__GENUS : 2 __CLASS : Win32Reg_AddRemovePrograms __SUPERCLASS : __DYNASTY : Win32Reg_AddRemovePrograms __RELPATH : Win32Reg_AddRemovePrograms.ProdID="{93F653D3-ED8B-4A04-BA58-3DF60B37D58B}" __PROPERTY_COUNT : 5 __DERIVATION : {} __SERVER : NAME_HIDDEN...
-
I need some help with a query to create a collection for Visio Pro and Project Pro 2016 - en-us. When i just query for i am getting results, but when i add en-us i am getting nothing, but i know i have them out there
-
Running 1610, I stumbled across something yesterday, and I'm wondering if anyone else has seen this: changing just the name of a query used to populate a collection breaks the collection. Steps to replicate: Change the name of the query being used as a membership rule for a collection.... -
Hi, Our current Task sequence for the Surface pro devices has been working great for sometime. Now with our entity moving towards Windows 10, I'd like to just add on the driver package step in my task sequence to get the needed driver package at it's desired OS. Currently, I have one driv...
-
hi guys, I need to come up with a report that will show how many machines received any application deployment and that it was successful. any ideas queries out there that can help me accomplish this task? we do a lot of deployments on a daily basis but i need to show this report to tally a...
-
Hi, all. SCCM 2012 SP1 with CU5. I'm seeing weirdness when setting up device collections that attempt to include systems based on both 32 bit and 64 bit applications being installed. I'm trying to combine "Installed Applications.Display Name" (SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName) w...
-
I work at a community college and we have sccm clients running Office versions from 2003-2013. I have scoured the web trying to find a query that could accomplish this task, but with my lack of SQL knowledge and specificity of the statement, I couldn't find a solution. Any thoughts?
-
Hi, Does anyone know where to pull info like an error from Windows Update? I want to make a SCCM-collection based on computers that get a specific error in Windows Update. Appreciate the help guys
-
Hi. I'm hoping someone has an easy answer to this.... I need to create a SCCM collection which membership is based on the clients Content location. We have an environment with just over 147 Distribution points (Primary, Secondary, and DP's below both these primary & secondary sites)...
-
Hello All, I'm looking for a query or report that will return the network information for all systems or all machines in a collection. Our environment unfortunately still uses wins and I need to see how many machines out in the wild might be missing their secondary wins server address. Googl...
-
I have a working query (Membership Rule) that gathers computers into a collection based on computer name. I also have a working query that gathers by OS (in this example we will use Windows 7). I have been trying to get the two combined into one query (basically an "and" statement instead of... -
I am looking for a query that finds all computers joined to the domain since XX date. I tried using the query below which looks back over the last week for new computers but this also discovers any computers that have been modified in the last 7 days. Does anyone have a query that is based on date...
-
I am working on helpdesk remediation strategies for virus notifications. I have setup alerts and find that most viruses get cleaned so the machine does not show up in the at risk collection. I want to setup a collection where a machine is infected so my helpdesk can deploy a cleaning package if th...
-
I've looked around a bit but have yet to come up with a good query or report to show the number of physical processors on our servers. Can anyone help? -
Hi we've a large number of devices with a few PCI and PCIe devices installed, not in the same slots. would like to push out a configuration script, the settings of which, for long-winded reasons or prerequisites, depends on how many, and which, slots are in use. the solution to this would theref...
-
Morning Guys, I have searched everywhere online for a query that can help me list all installed softwares on all computers to include Product ID & Version. I need to uninstall an application from all computers but the problem is that there are no install files and there is about 6 different... -
Hello everyone, I have a query that I'm unable to make. Here's the situation. I have a collection which contain x number of computer (let's say 200). I want a query that return the top x computer from the list (let's say 33% of it or top 50 computers) and put them into a collection. The idea...
-
I'm pretty new to building queries and am currently trying to familiarize myself with SQL and the SQL Views to further help run queries. I've been having a hard time trying to build a collection of computers that have one of our inventoried software items on it. Within Inventoried Software,...
-
Does anyone have a clue on a query that would return machines with any Version of SQL Server installed? I'm trying to create a collection of SQL machines. Thanks!!
-
i have a simple name query (System.Name is like "clma06v%) i'm running it agains all systems and the query returns 9 clients, but if i go to all systems and search for clma06v it returns all 24. this seems to be happening on my other queries also. i'm running sccm 2012 r2
-
Hello, i use the following query to get a license report but i´m not quite happy with the result and don´t know how to edit it. declare @ChannelCode varchar(32) select @ChannelCode = 'All' declare @ProductName nvarchar(255) select ProductName, FamilyName, VersionCode, coll.Name, MAX(Ver...
-
Hey Guys, I am in the need of a query , report or script that will generate a list of all of the applications that use a specific version of Java. I've used report Software 01A and as it does give me all of the versions of software I need to know what applications actually have a dependency...
