Push Ok. As you'll be able to see from the screenshot down below, my depend went down by two considering the fact that I by now had properly deployed it to fifty percent my examination equipment.
This page uses cookies that will help personalise written content, tailor your practical experience and to maintain you logged in in the event you sign-up.
vAlertResolutionState ars internal join Warn.vAlert alt on ars.alertguid = alt.alertguid wherever statesetbyuserid like '%username%' purchase by statesetdatetime --To perspective a rely of all alerts closed by all buyers:
I are actually requested to deliver a summary of all apps installed on just about every Laptop within our Business using SCCM. Does anybody Have a very recommendation on the place to locate a query to do this?
The datetime data style represents An immediate in time, ordinarily expressed being a date and time of working day. Time values are calculated in 1-next units. A datetime price is always in the UTC time zone. Normally Specific day time literals in ISO 8601 format, for example, yyyy-mm-dd HH:MM:ss
I have found a number of very good internet sites which have a lot of query samples. I use the 1 by Anders Rodland Quite a bit, have found it quite useful. Hope this all can help
Meta Server Fault your communities Sign on or log in to personalize your listing. a lot more stack Trade communities business site
can u mail me the query which u have pasted into studies to [email protected] please? Reply SCCM SQL Query Joey April 6, 2011 at 6:forty four AM Source · Edit Hey Eswar, Continue to no go. Here's the mistake i get After i debug in sql over the server While using the database is. Im sorry but i am not a sql man or woman.
Simultaneously I could not locate the procedure home to explicitly recognize a computer as being a laptop or a desktop.
Administration wanted me To place alongside one another a SQL report for numerous versions of a similar software. This specific circumstance proved challenging because the logic included including an "or" for the appliance versions and an "and" for the publisher in the "in which" part. This query did the trick for me:
In such cases, PC1 is going to be excluded out of your selection considering the fact that PC1 was in the collection inside your exclude rule. I'd 4 pcs in my setting without Adobe Reader mounted
The beneath queries are helpful for assessing the site and hierarchy information from SCCM Site servers.
Delete any textual content already within the ‘Query Statement’ box and copy and paste the query over in the box
The script below really began like a By Request script that I was asked to produce for the reader who planned to know How to define devices SCCM SQL Query with any versions of both UTorrent or BitTorrent mounted.