CCMBlogs

Search
Skip to content
  • Home
  • About
SCCM CMPivot

CMPivot Join Operator Example

August 22, 2019 Admin

New to CMPivot with the SCCM 1906 update is the Join operator.

Limitations
  • The join column is always the Device field.
  • Maximum of 5 joins per query.
  • Maximum of 64 combined columns.
Example

ComputerSystem
| project Device, Manufacturer, Model
| join (OperatingSystem | project Device, OSVersion=Caption)

https://docs.microsoft.com/en-us/sccm/core/servers/manage/cmpivot#bkmk_cmpivot_joins

 

Post navigation

Previous PostCMPivot Standalone InstallerNext PostSCCM Reports Fail to Run – Incorrect User Name or Password Error for Default Data Source

Real world sys admin – getting the job done without the need to stroke your own ego

Categories

  • Active Directory
  • Adobe Reader
  • App-V
  • AppSense
  • Azure
  • Exchange
  • Group Policy
  • MDT
  • QNAP
  • SCCM
  • SCCM CMPivot
  • SCOM
  • Sophos
  • VMware
  • Windows 10
  • Windows Client
  • Windows Phone
  • Windows Server
  • WSUS

Archives

  • September 2019
  • August 2019
  • June 2019
  • August 2018
  • May 2018
  • November 2017
  • October 2017
  • August 2017
  • October 2016
  • July 2016
  • June 2016
  • May 2016
  • February 2016
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • March 2015
  • February 2015
  • November 2014
  • October 2014
  • July 2014
  • June 2014
  • May 2014
Proudly powered by WordPress