While this data might not be as granular as needed or sometimes might require little bit of manual updates, it certainly provides you with a solid starting point, if not more.
Management of the building mapping file
Once the file is created, you also need to think about ongoing management of that file. Like updates, addition of new sites that went live and other updates. The identification of subnets that are potentially missed in the file is another important aspect. CQD always requires you to upload a new, full file – there is no concept as incremental updates for the building file. CQD will also enforce integrity of that file, you must not have overlapping or duplicate subnet information in that file. The CQDTools module supports you as well:
Get-BuildingMappingFromADSites -InputFileName MyCQDFile.csv
Where can I get the PowerShell Module?
This PowerShell module is published to PowerShell Gallery. If you are running PowerShell 5 or higher, which is a pre-requisite for this module, simply run Install-Module CQDTools to download and install the module directly from PS Gallery.
What else do I need to know?
The functions all come with help content and have optional parameters. E.g. if you want to get data from all authorized DHCP servers in your environment, you would run:
All functions have help context and examples, so you can run get-help Get-BuildingMappingFromMsftDHCP to get more details on the function, how it works and parameters that you can use.
These functions are exposed:
Call to Action
Overview on CQD
Videos that will help you learn more about CQD and how to use it
CQD Building file documentation
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.