- #ADOBE ACROBAT DC SERIAL NUMBER GOOGLE DROUPS HOW TO#
- #ADOBE ACROBAT DC SERIAL NUMBER GOOGLE DROUPS SOFTWARE#
- #ADOBE ACROBAT DC SERIAL NUMBER GOOGLE DROUPS FREE#
Last 50 events from the Application event logĮventLog('Application') | order by DateTime descĮventLog('System') | order by DateTime desc Last 50 events from the Application event log from a specific computerĮventLog('Application') | where (Device = 'DeviceName') | order by DateTime desc List all C:\ disk information from all devicesĭisk | where (Description = 'Local Fixed Disk') | where (Name = 'C:') Search a specific disk based on serial numberĭisk | where (Description = 'Local Fixed Disk') | where (VolumeSerialNumber = 'YourNumber') List all HP devices based on Manufacturerĭevice | summarize dcount( Device ) by Manufacturerĭevice | summarize dcount( Device ) by Modelĭevice | where ManuFacturer = 'VMware, Inc.' List all Dell devices based on Manufacturerĭevice | where (Manufacturer like 'Dell') List all Lenovo devices based on Manufacturerĭevice | where (Manufacturer like 'Lenovo') List all Microsoft devices based on Manufacturerĭevice | where (Manufacturer like 'Microsoft') List 50 last lines of a specific SCCM log fileĬcmLog('CCMLogName') | order by DateTime desc | project Device, LogText, DateTimeĪctive Tcp connection in or out of a specific device to a specific destination'Ĭonnection | where (Device = ''DeviceName') | where (Server = ''ServerName')Īctive Tcp connection in or out of the device to a specific destinationĬonnection | where (Server = ''ServerName') List 50 last lines of a specific SCCM log file on a specific computerĬcmLog('CCMLogName.log') | where (Device = 'DeviceName') | order by DateTime desc | project Device, LogText, DateTime
#ADOBE ACROBAT DC SERIAL NUMBER GOOGLE DROUPS SOFTWARE#
List all Auto Start Software on a specific deviceĪutoStartSoftware | where (Device = 'xx')ĪutoStartSoftware | where (Product = 'ProductName')īios | summarize dcount( Device ) by Versionįind a specific device based on bios versionįind a machine having a specific serial numberīios | where SerialNumber = ('your serial') List application crash on a specific deviceĪppCrash | where (Device = 'DeviceName')
List on which machine an admin is administratorĪdministrators | where (Name = 'DOMAIN\\USERNAME')ĪppCrash | summarize dcount( Device ) by FileName List all Active directory user that are administrator of their machineĪdministrators | where (ObjectClass = 'User') | where (PrincipalSource = 'ActiveDirectory') Latest queries added on October 23rd 2020. We hope it helps you adopt this new feature.
#ADOBE ACROBAT DC SERIAL NUMBER GOOGLE DROUPS FREE#
Here’s the SCCM CMPivot Query list, feel free to share your own and as in my other Set of Operational Collection script, this list will evolve over time so come back often to see that new addition we’ll make. At any time you can use | project Manufacturer, Model at the end of any query to display only desired column ( Manufacturer, Model in this case)Īfter a while of playing with it, we thought it would be useful to share a list of queries that we build.Watch out for Uppercase letter, Where is not the same as where. If you use an “W”, you’ll end up with a Failed to parse query error.This results in a pretty simple language but there are a few catches that I learned : Each operator accepts a tabular dataset “from the pipe”, and additional inputs (including other tabular data sets) from the body of the operator, then emits a tabular data set to the next operator that follows: The composition is represented by the pipe character (|), giving the statement a very regular form that visually represents the flow of tabular data from left to right. The typical structure of a tabular expression statement is a composition of client entities and tabular data operators (such as filters and projections). The official Microsoft documentation states : We are pretty comfortable with various programming language but CMPivot uses a subset of the Azure Log Analytics data flow model for the tabular expression statement which was new for us. When we began using CMPivot, we were a bit lost. The goal of this post is to give you a list of SCCM CMPivot Query Examples.
#ADOBE ACROBAT DC SERIAL NUMBER GOOGLE DROUPS HOW TO#
If you are not familiar with this new feature, you can read about it in our previous post which describes how to use it. SCCM CMPivot has been introduced in SCCM 1806 and it’s making its way to be a pretty useful addition.
0 kommentar(er)
