Reports



  • I am trying to create a report and most of the information I need is in the report created from Inventory, but there are only a few of our computers listed there. How does the ‘inventory’ get populated? I did a report by ‘host’, but that does not have as much information in it.
    thanks, chigley



  • 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:

    $report->addCSVCell(_("Group Name"));
    

    then the SQL reads now as:

    $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)
    ";
    

    And lastly add this to the last array section

    $report->addCSVCell($ar["groupName"]);
    

    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 :) )


  • Moderator

    hey i see what you mean, that makes sense. How about add in to feature request forum?



  • 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… :)


  • Moderator

    you could use MS Access and connect to the mysql DB on FOG and do custom reporting that way. that what we are doing


  • Moderator

    @BryceZ, post: 1330, member: 2 said:

    The inventory report is built from the inventory table, which is populated by running a full-inventory task on your hosts. This is done when selecting Full Inventory and Registration from the boot menu on new hosts, and can be queued from the FOG console for existing hosts.
    I have only ever used quick host inventory and my Inventory Report has all PC/LAPTOPS in with all the information ie: name, make, model, processor, serial, ram, os, etc.



  • Apologies for hijacking the thread - I’d like to create a report also (to export a list of hosts in groups) but can’t seem to find any information on how I create or copy an existing report and edit it. I know it has to be uploaded in php format but that’s it. Are there any primers anywhere online to nudge me in the right direction? I’ve searched the forums to no avail

    cheers,



  • The inventory report is built from the inventory table, which is populated by running a full-inventory task on your hosts. This is done when selecting Full Inventory and Registration from the boot menu on new hosts, and can be queued from the FOG console for existing hosts.


Log in to reply
 

890
Online

38716
Users

10544
Topics

99831
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.