List Windows hosts which we can not log into
...
The following query gives a list of Windows hosts which we are unable to log in to. This should work with all versions of iQSonar.
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
SELECT p.Name as Project
, TargetName
, HostnameOrIP
, SuspectedOrScannedOS
, Status
, Reason
FROM [history].[v_DiagnosticsDeviceList] vDDL
INNER JOIN config.t_Project p ON vDDL.ProjectID = p.ProjectID
WHERE Reason = 'Access Denied'
AND vDDL.ProjectID in (1,2,3)
AND SuspectedOrScannedOS =Like 'Windows%Windows%' |
Additional Details - show which credentials failed
The above query showed which hosts we cannot log in to. It does not show what the credentials we tried are. The following queries will show which credentials were tried per host.
| Warning |
|---|
These queries work with iQSonar releases up to and including Fu R3. They do NOT work with iQSonar Gwynn R1 or later due to changes to the history.t_ConnectionHistory tableChanges were made to some underlying tables in Gwynn R1 and Gwynn R2 to reduce the amount of history saved as the diagnostic information can grow. In the Gwynn R3 release the option to preserve or delete this diagnostic can be selected in the user interface. Instructions on how to keep the history data can be found on this page. |
iQSonar uses multiple protocols to connect to targets running various versions of Windows. The different connection types can give different information about the target.
...