Below is the SQL code needed to retrieve all of the collections from ConfigMgr. This is useful when creating custom reports that need to be scoped to a specific collection. The query below selects the CollectionName and CollectionID columns and sorts the CollectionName column alphabetically.
|
1 2 3 |
SELECT CollectionName, CollectionID FROM v_Collections ORDER BY CollectionName |
Results from the query on my test system.
If you need to make a copy of a group policy, using the Group Policy Management Console can be a slow process. Using PowerShell is a much faster process.
All you need is the name of the source GPO copied to the clipboard.
|
1 |
Copy-GPO -SourceName "Edge Browser Settings - Test" -TargetName "Edge Browser Settings - Prod" |
You can also copy by using the GUID of the source and/or destination GPO. In addition, you can copy GPOs between domains.
|
1 |
copy-gpo -SourceName "Edge Browser Settings - Test" -SourceDomain "corp.viamonstra.com" -TargetName "Edge Browser Settings - Prod" -TargetDomain "lab.viamonstra.com" |
I don’t have an image of copying between domains because my lab only contains a single domain.
The last hardware scan is stored in the view v_GS_WORKSTATION_STATUS. When joined with either v_R_System_Valid or v_R_System, you can retrieve the last hardware scan for a computer.
The SQL code below will return the last hardware scan date for all computers in the ConfigMgr system.
|
1 2 3 |
SELECT v_R_System_Valid.Netbios_Name0, v_GS_WORKSTATION_STATUS.LastHWScan FROM v_GS_WORKSTATION_STATUS INNER JOIN v_R_System_Valid ON v_GS_WORKSTATION_STATUS.ResourceID = v_R_System_Valid.ResourceID |
If you need to return the last hardware scan for a single computer you can use the query below to filter by the computer name. In this example, we filtered on computer ‘pc01’.
|
1 2 3 4 |
SELECT v_R_System_Valid.Netbios_Name0, v_GS_WORKSTATION_STATUS.LastHWScan FROM v_GS_WORKSTATION_STATUS INNER JOIN v_R_System_Valid ON v_GS_WORKSTATION_STATUS.ResourceID = v_R_System_Valid.ResourceID WHERE (v_R_System_Valid.Netbios_Name0 = N'pc01') |
