< Back
Find-MissingBuildingsInCQD
Post
NAME Find-MissingBuildingsInCQD
SYNOPSIS
Helps you with CQD building mapping maintenance. Finds unmapped subnets in CQD that show the same public IP as
seen for mapped subnets, reports found subnets.
SYNTAX
Find-MissingBuildingsInCQD [[-ResultsFilePath] <String>] [[-Days] <Int16>] [-DisplayResults]
[[-VerboseLogFileName] <String>] [<CommonParameters>]
DESCRIPTION
Gets stream count for all subnets from CQD including public IP (second reflexive local IP) and second building.
Checks all unmapped subnets (subnets with no building information) if the public IP is also seen for a mapped
subnet. It is very likely that those unmapped subnets actually belong the the same building(s). Found subnets,
streamcount and matching buildings are reported. The Results of this script can be used to enhance and further
complete the CQD building mapping file.
PARAMETERS
-ResultsFilePath <String>
Path and filename for the Results. Default: .\\PotentialMissedSubnets.csv
Required? false
Position? 1
Default value .\\PotentialMissedSubnets.csv
Accept pipeline input? false
Accept wildcard characters? false
-Days <Int16>
Number of days for which data is returned from CQD. Default: 28 days.
Required? false
Position? 2
Default value 28
Accept pipeline input? false
Accept wildcard characters? false
-DisplayResults [<SwitchParameter>]
If specified, all Results are shown after the script completes, in addition to saving all Results in the
Results file.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-VerboseLogFileName <String>
Required? false
Position? 3
Default value VerboseOutput.Log
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
NOTES
????????? 2018 Microsoft Corporation.??????????????? All rights reserved.??????????????? This document is provided
"as-is." Information and views expressed in this document, including URL and
other Internet Web site references, may change without notice.??????? ???????
This document does not provide you with any legal rights to any intellectual
property in any Microsoft product. Skype for Business and Microsoft Teams customers
and partners may copy, use and share these materials for planning, deployment
and operation of Skype for Business and Microsoft Teams.??????? ???????
Will prompt for credentials to read data from CQD. Provide a user with CQD access, a member of any of these
O365 admin roles work: Report Reader, Skype Admin, Tenant Admin.
-------------------------- EXAMPLE 1 --------------------------
PS C:\\>Find-MissingBuildingsInCQD
Connects to CQD, reads data for the past 28 days (plus 2 day offset to account for CQD data delay), analyses
Results and reports out any subnets that seem to be missing from the CQD building file.
RELATED LINKS
https://docs.microsoft.com/en-us/SkypeF ... using-call
-quality-dashboard#upload-building-information
SYNOPSIS
Helps you with CQD building mapping maintenance. Finds unmapped subnets in CQD that show the same public IP as
seen for mapped subnets, reports found subnets.
SYNTAX
Find-MissingBuildingsInCQD [[-ResultsFilePath] <String>] [[-Days] <Int16>] [-DisplayResults]
[[-VerboseLogFileName] <String>] [<CommonParameters>]
DESCRIPTION
Gets stream count for all subnets from CQD including public IP (second reflexive local IP) and second building.
Checks all unmapped subnets (subnets with no building information) if the public IP is also seen for a mapped
subnet. It is very likely that those unmapped subnets actually belong the the same building(s). Found subnets,
streamcount and matching buildings are reported. The Results of this script can be used to enhance and further
complete the CQD building mapping file.
PARAMETERS
-ResultsFilePath <String>
Path and filename for the Results. Default: .\\PotentialMissedSubnets.csv
Required? false
Position? 1
Default value .\\PotentialMissedSubnets.csv
Accept pipeline input? false
Accept wildcard characters? false
-Days <Int16>
Number of days for which data is returned from CQD. Default: 28 days.
Required? false
Position? 2
Default value 28
Accept pipeline input? false
Accept wildcard characters? false
-DisplayResults [<SwitchParameter>]
If specified, all Results are shown after the script completes, in addition to saving all Results in the
Results file.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-VerboseLogFileName <String>
Required? false
Position? 3
Default value VerboseOutput.Log
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
NOTES
????????? 2018 Microsoft Corporation.??????????????? All rights reserved.??????????????? This document is provided
"as-is." Information and views expressed in this document, including URL and
other Internet Web site references, may change without notice.??????? ???????
This document does not provide you with any legal rights to any intellectual
property in any Microsoft product. Skype for Business and Microsoft Teams customers
and partners may copy, use and share these materials for planning, deployment
and operation of Skype for Business and Microsoft Teams.??????? ???????
Will prompt for credentials to read data from CQD. Provide a user with CQD access, a member of any of these
O365 admin roles work: Report Reader, Skype Admin, Tenant Admin.
-------------------------- EXAMPLE 1 --------------------------
PS C:\\>Find-MissingBuildingsInCQD
Connects to CQD, reads data for the past 28 days (plus 2 day offset to account for CQD data delay), analyses
Results and reports out any subnets that seem to be missing from the CQD building file.
RELATED LINKS
https://docs.microsoft.com/en-us/SkypeF ... using-call
-quality-dashboard#upload-building-information