5 Replies Latest reply on Aug 9, 2017 11:27 AM by Cory Garcia

    BMC Discovery - No Access Report

      Share This:

      Hi,

      Could someone please help in getting a query or a method to get below:

       

      a query to get a report for all NO ACCESS servers of last one week or last 7 seven scans with date format. we have a discovery scans running everyday.

        • 1. Re: BMC Discovery - No Access Report
          Varun Kaulapure

          Dear

           

          search DiscoveryAccess where end_state matches "NoAccess" and starttime > (currentTime() - 7*24*3600*10000000)

          HTH.

           

           

          Thanks,

          Varun

          1 of 1 people found this helpful
          • 3. Re: BMC Discovery - No Access Report
            Andrew Waters

            Is that really what you are after? The reports all NoAccess DiscoveryAccesses, so even if a machine was temporarily inaccessible and was then okay you would still report a NoAccess.

            • 4. Re: BMC Discovery - No Access Report

              Hi Waters,

              you're right on that!

               

              i need a report of servers which are failing with credentials. so any type of servers (windows, linux etc) which are failing with the credentials we have setup in our addm. because we have all of those credentials which we have in our company.

               

              in our environment we have many new servers getting commissioned and they don't have these accounts setup by default. so we're in a process to make our server team aware of these servers to make them accessible.

               

              Through this method i have to filter out many thins, remove dulicates and then hit a compare against the successful discovered CIs then remove the ones which are through with discovery and keep undiscovered with NO ACCESS.

               

              is there a better way you could suggest to get me the list of servers which have only No ACCESS and never been successfully discovered for all server types??

              1 of 1 people found this helpful
              • 5. Re: BMC Discovery - No Access Report
                Cory Garcia

                We have a need for this as well

                 

                I have been able to group the classes we need and pull a good report for Good Access but I am unable to get away from our current process for No Access.

                 

                A query that combines all Hosts / Network Devices / Printers along with No Access and has no duplicates is a goal of ours.

                 

                If anyone has one please share.

                 

                 

                 

                 

                This is the Query for Good Access that I am working on for another task

                 

                I want to use this one and add the functionality of our Access Report Below and Overcome the limitation of the Access Report (not showing All Good Access) - at the same time I want it to be able to Show No Access without duplicates (a device that shows up as both Good Access and No Access)

                 

                SEARCH FLAGS(no_segment)
                Host,NetworkDevice,Printer

                show
                site as 'Site',

                name
                as 'Name',

                host_type
                as 'Host Type',

                os_type
                as 'OS Type',

                os_version
                as 'OS Version',

                #Host:HostedSoftware:InstalledSoftware:Patch.name
                as 'Installed Patches',

                nodekind
                as 'Nodekind',

                vendor
                as 'Vendor',

                type
                as 'Type',

                model
                as 'Model',

                os_class
                as 'OS Class',

                last_update_success
                as 'Last Update Success',

                #InferredElement:Inference:Associate:DiscoveryAccess.

                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.access_method
                as 'Access Method',

                #InferredElement:Inference:Associate:DiscoveryAccess.endpoint
                as 'Scanned via',

                hostname
                as 'Hostname',

                os as 'OS'

                 

                 

                Here is the current Access Report we use For Good Access and No Access (It runs into issues where if a device fails a specific run and is still Discovered - it doesn't show on Good Access - so our Good Access Numbers are erroneous)

                 

                search
                DiscoveryAccess where _last_marker and endtime and
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os_class
                order by discovery_starttime desc show
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os_class as
                'Discovered OS Class', whenWasThat(discovery_starttime) as 'When',
                (#DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.last_access_method
                = 'rcmd' and
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.last_slave or
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.probed_os and
                'Probe' or
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.last_access_method)
                as 'Current Access', endpoint,
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.hostname as
                'Hostname',
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os as
                'Discovered OS',
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os_type as
                'OS Type', #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os_version
                as 'OS Version', (nodecount(traverse
                DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo traverse
                flags(include_destroyed) Primary:Inference:InferredElement:Host where not
                destroyed(#)) > 0) as 'Host Node Updated', (reason or '') as 'Reason not
                updated', (nodecount(traverse DiscoveryAccess:Metadata:Detail:SessionResult
                where not provider) > 0) as 'Session Results Logged' processwith
                flags(no_segment) where nodecount(traverse Member:List:List:DiscoveryRun where label in ['A', 'B', 'C'])
                show #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os_class
                as 'Discovered OS Class', @1, @2, endpoint,
                #Member:List:List:DiscoveryRun.label as 'Label',
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.hostname as
                'Hostname',
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os as
                'Discovered OS',
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os_type as
                'OS Type', #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os_version
                as 'OS Version', @8, @9, @10, end_state as 'End State', inferred_kind as
                'Inferred Kind' processwith flags(no_segment) show
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os_class as
                'Discovered OS Class', @1 as 'When', @2 as 'Current Access', endpoint as
                'Endpoint', #Member:List:List:DiscoveryRun.label as 'Label',
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.hostname as
                'Hostname',
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os as 'Discovered
                OS', #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os_type
                as 'OS Type',
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os_version as
                'OS Version', @9 as 'Host Node Updated', @10 as 'Reason not updated', @11 as
                'Session Results Logged', end_state as 'End State', inferred_kind as 'Inferred
                Kind', device_summary as 'Device Summary', kind as 'Kind' processwith
                flags(no_segment) show
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os_class as
                'Discovered OS Class', @1 as 'When', @2 as 'Current Access', endpoint as
                'Endpoint', #Member:List:List:DiscoveryRun.label as 'Label',
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.hostname as
                'Hostname', #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os
                as 'Discovered OS',
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os_type as
                'OS Type',
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.os_version as
                'OS Version', @9 as 'Host Node Updated', @10 as 'Reason not updated', @11 as
                'Session Results Logged', end_state as 'End State', inferred_kind as 'Inferred
                Kind', device_summary as 'Device Summary',
                #DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:DeviceInfo.kind as 'Kind'