Foundstone SQL Query-list hosts with unknown OS'es
(version: MVM 7.0+)
Mcafee support was not able to help me with this query, however after working within MVM's Faultline database, I came up with the following.
This query's output will be all IP addresses, discovered DNS names, discovered netbios names, etc...this is a good supplement to the manage OS fingerprints function in FCM
Use Faultline SELECT vwAssets.IPAddressStr, Hosts.DNSName, Hosts.NBName, OSCategories.OSCategoryName, HostOSPrints.Percentage, OsPrints.Type, OsPrints.Description FROM Hosts INNER JOIN HostOSPrints ON Hosts.HostID = HostOSPrints.HostID INNER JOIN OsPrints ON HostOSPrints.OSPrintID = OsPrints.OSPrintID INNER JOIN OSCategories ON Hosts.OSCategoryID = OSCategories.OSCategoryID AND OsPrints.OSCategoryID = OSCategories.OSCategoryID INNER JOIN vwAssets ON Hosts.HostID = vwAssets.HostID WHERE (HostOSPrints.Percentage < 100)
