Hey Falko
thanks for that. The host report gives me the majority of what I need however at work I’ve just completed an audit of 300+ machines all grouped by the bank of desks they’re sitting at. I’d like to be able to export a report showing all the hosts per a host report but have an extra column listing the group they are assigned to. Can then match up with AD which also has the same host in a group setup to ensure all machines are in AD and non-live machines can be removed from AD (but optionally still kept in the Fog Server database and added to a “spares” group).
I was hoping I could just edit the existing fog host report.php file somewhere to add the relevant code to include the group column.
Access may be a path forward but Access and SQL is a somewhat closed book to me…