Foundstone SQL Query-list hosts with unknown OS'es
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)