I actually found another user on the forums who posted a similar request to my own. I cross posted there hoping to get more views and thanks to some SQL help from user Moss managed to edit the host report to now include group names.
I’ll post the “edited highlights” here but if someone would like the complete php file or if it’s permitted to post here I can do so
Firstly I downloaded a copy of the [B]Host List.php[/B] file from [B]/var/www/fog/management/reports/[/B] to work on
Under the echo ( “<div>” ); section I added this line:
[CODE]$report->addCSVCell(_(“Group Name”));[/CODE]
then the SQL reads now as:
[CODE]$sql = "SELECT
*
FROM
hosts
left outer join images on ( hostImage = imageID )
left outer join supportedOS on ( hostOS = osID )
left outer join groupMembers on ( hostID = gmHostID)
left outer join groups on ( gmGroupID = groupID)
";[/CODE]
And lastly add this to the last array section
[CODE]$report->addCSVCell($ar[“groupName”]);[/CODE]
I actually stripped out a number of things to keep the report more concise for my own use - I only really want to see which bank of desks a particular pc is sitting at. From the looks of things if you know your SQL and/or PHP or are prepared to learn it (or like me cobble something together from the existing code and a lot of forum searches) the reporting feature can do quite a lot.
Hope this helps someone else out there.
cheers (and apologies to mods for cross threading - won’t happen again 🙂 )