• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

Merged Inventories

Scheduled Pinned Locked Moved
General
2
2
1.0k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • 0
    007Bob
    last edited by Sep 19, 2012, 9:41 PM

    We currently run several (more than 12 at this time) Fog Servers in our school district (7000 workstations running Win 7). It works great for imaging, snap-ins and inventory. I am looking for a solution to merge the inventories of the servers for reporting purposes. I would like to pull from the servers and create one large Excel spreadsheet rather than have to pull individual reports and merge them. Any ideas? Thank you!

    1 Reply Last reply Reply Quote 0
    • C
      chad-bisd Moderator
      last edited by Sep 20, 2012, 1:27 AM

      In a separate database import the hosts and inventory tables from all the fog servers. For each table add a new field that contains the server identifier so that host1 from server A can be differentiated from host1 on server B. basically change the index on the hosts and inventory tables from being a single field to be comprised of hostid and serverid. You’ll have to decide on the serverid values and insert them into the reporting tables as you import from each server.


      If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

      1 Reply Last reply Reply Quote 0
      • 1 / 1
      1 / 1
      • First post
        1/2
        Last post

      270

      Online

      12.0k

      Users

      17.3k

      Topics

      155.2k

      Posts
      Copyright © 2012-2024 FOG Project