I m trying to create new query to get Systems Information, but i din't find Default Gateway option while adding columns under column tab.
Can someone help me to get Default gateway through ePO queries.
Thanks in Advance.
Solved! Go to Solution.
Unfortunately the "Gateway" detail does not exist by default under the EPOComputerProperties table but perhaps you can use a custom variable to detect system's gateway as stated under ePO help file...?
Custom 1 through 4 — These are the four entries per system in the McAfee ePO database which you can use for your own purposes.
IT's not really about new queries but it's all about custom fields on the computer properties table.
By default McAfee Agent is not picking your computer default gateway because it's not been designed to do it (you'll se a lot of fields under system properties but not a gateway field) so you can perhaps use these Custom fields and set them (at least one of them) to read and display computer's gateway.
The problem is that you have to set this field directly into EPOComputerProperties table (I may be wrong, perhaps someone else con clarify this) and I don't really know how to do it as i haven't found any KB about this