Latest FOG 0.33b
-
ok… we’ve finessed our export/imports and are confident we can make 033b happen. However one tiny problem that’s probably easy to fix., when you search for any piece of hardware like a serial number or asset tag, search results are 0.
We use this quite extensively to search for Dell tags.Can you try on in your database to search for something in the hardware… like [FONT=Ubuntu][COLOR=#555555]System Serial Number ?[/COLOR][/FONT]
-
Yes I can,
Relatively speaking this is very easy, except the search protocols don’t look at the inventory tables … yet, I’ll try to look into this over the weekend if that’s okay!
-
yes ! that’s fine… we do appreciate the time and effort ! Fog is the cornerstone of our IT department
-
I already have this figure out and, somewhat, tested.
For all:
Not only can you now search for host by hostname, mac, id, description, serial, or what have you! You can also search for a host by group name from the hosts page, and you can search for a group containing a specific hostname. I thought this could be useful and hope you all think the same.
r979 out.
Something to be aware of, as well,
Searching by ID’s isn’t supported, yet. It would only take an add to the searchQuery string in <class>Manager.class.php though!
-
[quote=“Ed Blom, post: 18407, member: 2503”]ok… we’ve finessed our export/imports and are confident we can make 033b happen. However one tiny problem that’s probably easy to fix., when you search for any piece of hardware like a serial number or asset tag, search results are 0.
We use this quite extensively to search for Dell tags.Can you try on in your database to search for something in the hardware… like [FONT=Ubuntu][COLOR=#555555]System Serial Number ?[/COLOR][/FONT][/quote]
how did you export and import from .32 to .33
-
exported from .32 using phpmyadmin.
What was important for us was the host name, mac address and hardware info.
So we exported to .csv format the hosts from the old .32 install.
Finessed the data in excel, we had to add four columns. then imported the .csv in the new install.
same with printers and images.
The easiest one was inventory -which holds all your hardware info, this was a straight SQL export.So you need to csv export:
-
hosts
-
images
-
printers -if you use printers-
-
inventory (SQL table export)
Then use phpmyadmin on .33 and import into the sql.
I can be more specific, but that’ll be Monday when I’m back at work.
-
-
Thank you ed.
-
r981 out.
Added ID searching fields to the Group and Host searching elements.
Still working towards reintegrating Internationalization bits, but almost there!.
Moved inventory display to Inventory Class.
-
Hmm I’ve imported all my stuff and search does not work
-
You may have to ensure the hostid matches the inventory hostid
-
Also,
Have you upgraded to the latest revision? I’m guess you have, but that would only leave the thought from above. When you imported the hosts, did you import as CSV? If you did with CSV, it recreates the hostID’s so the Inventory table’s iHostID would be incorrect.
-
Yes I’m on R982, I’ve imported the hostid’s from CSV into a testserver then exported the SQL to my NEW testserver… I’ll double check, I can click on hardware for a host and get the correct info
BTW a search for a dell[FONT=sans-serif][COLOR=#000000] service tag, results in fog showing me all my hosts[/COLOR][/FONT]
-
What element of the search are you looking for?
Here are all the options that are searched for:
[php] public $searchQuery = ‘SELECT hosts.* FROM hosts
LEFT OUTER JOIN
(SELECT * FROM hostMAC WHERE hmMAC LIKE “%${keyword}%”) hostMAC
ON (hmHostID=hostID)
LEFT OUTER JOIN
inventory
ON (iHostID=hostID)
LEFT OUTER JOIN
(SELECT * FROM groups INNER JOIN groupMembers ON (gmGroupID=groupID) WHERE groupName LIKE “%${keyword}%” OR groupDesc LIKE “%${keyword}%”) groupMembers
ON (gmHostID=hostID)
WHERE
hostID LIKE “%${keyword}%” OR
hostName LIKE “%${keyword}%” OR
hostDesc LIKE “%${keyword}%” OR
hostIP LIKE “%${keyword}%” OR
hostMAC LIKE “%${keyword}%” OR
groupID LIKE “%${keyword}%” OR
groupName LIKE “%${keyword}%” OR
groupDesc LIKE “%${keyword}%” OR
iSysserial LIKE “%${keyword}%” OR
iCaseserial LIKE “%${keyword}%” OR
iMbserial LIKE “%${keyword}%” OR
iPrimaryUser LIKE “%${keyword}%” OR
iOtherTag LIKE “%${keyword}%” OR
iOtherTag1 LIKE “%${keyword}%” OR
iSysman LIKE “%${keyword}%” OR
iSysproduct LIKE “%${keyword}%”
GROUP BY
hostID DESC’;[/php] -
[FONT=Ubuntu][COLOR=#555555]If I do a search for [/COLOR][/FONT][FONT=monospace][COLOR=#dd0000]iSysserial[/COLOR][/FONT]
[FONT=Ubuntu][COLOR=#555555]HDYZDK1 or a host [/COLOR][/FONT][FONT=Ubuntu][COLOR=#555555]name like 2014-spare-01 or part of a name[/COLOR][/FONT]
[FONT=Ubuntu][COLOR=#555555]Fog will show ALL my hosts.[/COLOR][/FONT][FONT=Ubuntu][COLOR=#555555]Also doublechecked my hostID and inventory iHostID they match.If I seach for something I know is not there I get an error searching message.[/COLOR][/FONT]
-
When you look at inventory, are all the hosts sitting with the same information?
I have one of my systems, (while I’ve been testing) set with serial iSysserial as abcd1234, and another set to antidisestab (again, just to test) and when I search for serial, it gives me the proper host. If I search for something as simple as “abc” I have a few hosts which show up because their mac address contains that as well.
I’ve not been getting all my hosts though which makes me wonder what your individual host information is set as.
-
[S]I have 820 hosts… a mix of various Optiplexes and Lenovos. my naming convention is location,room,machine number[/S]
[S]so es-45-01 etc[/S][S]Went back into the sql database to make triple sure my ID’s matched up.[/S]
[S]I’m now in the process of creating a VM of a .33 with “new” hosts, to check if my imports messed it up[/S][COLOR=#ff0000][B]Scratch all of that, changed over to Firefox and it works ( I was using chrome with a ton of add-ons)[/B][/COLOR]
-
Yeah,
I use Chrome for most of my stuff, but try to test across all types, (IE, Firefox, Chrome, Safari, Mobile platforms) but I have no add-ons except ad-blocker for me!
-
r984 release.
Contains fixes for capone.php in looking for imageDD which always returns 0. It should have been looking for case [1-4] not [0-3] and should be looking for imageTypeID Field.
I fixed this, but did it on direct source. The next time I copied changes over, it got overwritten with the old data.
-
r985 is out,
User Tracking works properly. As far as I can tell, Printers seem to work as well. It seems to give the interactive desktop service if you’ve installed the printer, and then removed it. After a period of time it tries to readd that printer which seems to cause the popup of the IDS thing. Other than that, it seems to install in either case, and I’ve tested printing and it actually sends the job properly. I haven’t tested local or iprint, but I’m sure it will work in much the same fashion.
-
My capone is stuck on finding DMI… never does anything
