The 2026 Drupal Business Survey is open. Your response will help shape the future of the Drupal business ecosystem.I've create three content types that I'm using for an inventory project, which are:
hostname inventory
- contact person
hardware inventory
- serial number
- asset tag
- location
hardware model inventroy
- amps
- BTUs
The hostname uses a nodereference to link to the assocated hardware inventory (using the serial #) and in turn does as a nodereference to the hardware model inventory.
What I would really like to do is to have a view where I can join these three inventories together and use the nodeference fields for the join. To the best of my knowledge this currently isn't possible.
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | Easytouch_ITIL_data_definition.png | 27.72 KB | robert.redl@easytouch.cc |
Comments
Comment #1
robert.redl@easytouch.cc commentedAbout your 'Joining several content types together using nodereference to line up the fields'
Please have a look, how I used my first prototype to do some kind of IT-Management stuff.
(See the attached .png File at the Top of this comment).
Could you please give me a more detailed example, about what you want to do?
Something where I can see the detailed list of fileds, and how they are connected to the referring content types (the fields using noderef).
And also an example, how the endresult should look like.
Somewhere I have read that a field can be RE-USED. If this is also possible with noderef? - we have to try out.
I would also like to know your Drupal, and Module versions, to be able to troubleshoot the white screen issue for the block.
Comment #2
biohabit commentedsee below for the list of fields per content type and what i'm looking to do is have a table view where it would show on one line ....
the hostname {host inv}
host function{taxonomy}
OS{taxonomy}
contact person(s){host inv}
the associated hardware [nodereference to hw inv]
hw asset # {hw inv}
Location {hw inv}
model name [nodereference to hw model inv]
Amps {hw model inv}
BTUs {hw model inv}
I'm also planning on setting up a services inventory that would include a nodereference to the specific hostname that it runs on and, if appliciable, the specific hardware that it is license/attached to. I would love to have the option of some basic math functions on any columns that were integers so I could calculate max. Amps and BTUs where are rather important for a DR plan.
hostname inventory:
Purpose: Mostly for the hostnames (including Virtual Hosts, important CNAMES, samba instances, ... that [folks in specific organic groups] should be aware of. Devices without a typical hostname are not included in the hostname inventory.
fields
---------
hostname
Host Function [categories]
Operating System [categories]
Contact person(s)
sysadmin controlled host? [defaults to yes]
Host status [defaults to Production]
VHost or CNAME [Node Reference - hostname]
Associated Hardware [Node Reference - serial number]
Hostname Description
hardware inventory
Purpose: Primarily targeted at hosts/devices that are in asset run, but the Asset # is not a required field as there are several devices that are important, but not in asset run. The likely workflow for new hardware would be to get the serial number in the inventory and then wait for the asset # tag to arrive sometime later.
fields
----------
serial number
Associated host(s) [Node Reference - hostname]
Asset #
Location
Status [defaults to In Use]
MAC address
Hardware Model [Node Reference - model name]
hardware model inventory
fields
----------
model name
HW Model Manufacturer:
HW Model's Amp rating: [integer]
HW Model's BTU rating: [integer]
Input power (w): [integer]
HW_Model_Manuals:
Comment #3
biohabit commentedAs for the other problem with the php snipet resulting in the white screen of death, I'm running....
drupal 4.7.2
views 4.7.0 from June 20th
CCK cvs from June 12th
Organic Groups 4.7.0 from June 18th
the php.ini file is set to 32M of memory and there were no error messages of note in any of the logs.
Comment #4
biohabit commented