Jump to content


Photo

table reporting option


  • Please log in to reply
10 replies to this topic

#1 Will

Will

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 08 March 2007 - 01:20 PM

To anyone,

Total Network Inventory has saved me hours/days of inventorying 40 systems. The "Report" style reporting is beautiful, however, I have looked for a while to be able to build "Table" style reports, and can't find any way.

An example would be I would like a report to show me a column of computer names, next column OS's, next column key codes. The information is there, there is so much you could do with that information if you could transfer it to an Excel spreadsheet format.

Any ideas?

thanks in advance,

Will

#2 Zak

Zak

    Administrator

  • Root Admin
  • PipPipPip
  • 747 posts
  • Gender:Male

Posted 09 March 2007 - 02:34 AM

Any ideas?

thanks in advance,

Will

Hello, Will.

We undestand your thought and I should mention that we have already been working a while to add more customized reports, including statistic and table-style reports. Also we plan to add direct export to different formats: doc, xls, txt - bypassing reporting engine to avoid some restrictions.

However, it is now already possible to get information to Excel. You should build a full or brief report containing those categories you need now - and save it to CSV format, then you'll be able to open it from Excel (separation symbol is semicolon).
Softinventive Lab support

#3 Will

Will

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 09 March 2007 - 03:57 PM

Thanks, I shall try that. I'll let you know.

Will



Hello, Will.

We undestand your thought and I should mention that we have already been working a while to add more customized reports, including statistic and table-style reports. Also we plan to add direct export to different formats: doc, xls, txt - bypassing reporting engine to avoid some restrictions.

However, it is now already possible to get information to Excel. You should build a full or brief report containing those categories you need now - and save it to CSV format, then you'll be able to open it from Excel (separation symbol is semicolon).



#4 Zak

Zak

    Administrator

  • Root Admin
  • PipPipPip
  • 747 posts
  • Gender:Male

Posted 08 January 2008 - 09:43 AM

By the way, tabular reports are already there, just check that you have the latest version - 1.5.40 (latest build is 1047 now). They can be found at "Reports - Tabular reports" and you can customize the custom tabular report in "File - Options - Tab.report".
Softinventive Lab support

#5 OCF Rob

OCF Rob

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 11 January 2008 - 04:19 PM

By the way, tabular reports are already there, just check that you have the latest version - 1.5.40 (latest build is 1047 now). They can be found at "Reports - Tabular reports" and you can customize the custom tabular report in "File - Options - Tab.report".


Hi Zak-

New user of 350 nodes and love the SW...found a very odd bug, though. Brief report is missing some installed software pieces that exist in Full (so far from our quick lookover it seems to be MS Office 2003 Pro on select PC's...Full shows it and also the tabular report but Brief just omits it).

Any ideas?

Thanks!
Rob

#6 Zak

Zak

    Administrator

  • Root Admin
  • PipPipPip
  • 747 posts
  • Gender:Male

Posted 14 January 2008 - 10:15 AM

Hi Zak-

New user of 350 nodes and love the SW...found a very odd bug, though. Brief report is missing some installed software pieces that exist in Full (so far from our quick lookover it seems to be MS Office 2003 Pro on select PC's...Full shows it and also the tabular report but Brief just omits it).

Any ideas?

Thanks!
Rob


Hi Rob,
Thank you for paying our attention to this. This is really a bug, though not connected with MS Office or another particular program. It only happened when the number of software titles was even, then it divided the list in two parts and dropped the first title from the right column. We've found the same happening with "Program Files" folders. We have fixed this already, and this fix will be available with the nearest update of the program.
Softinventive Lab support

#7 Guest_smurf_*

Guest_smurf_*
  • Guests

Posted 18 January 2008 - 02:16 AM

Hi,

we audit over 800 Clients with Network Inventory (a very nice and cool piece oft software, btw!)
To add the Tabular reports was a great idea!
Is it possible to add other / more fields in the Tabular Custom Report? We need a Tabular Report where the free disk space on C Partition is listed. Any Idea? (At this time I get only the entire diskspace, cause in the Options Menu I can see and select only the Total HDD fields).

Thanks in advance

Smurf

#8 Zak

Zak

    Administrator

  • Root Admin
  • PipPipPip
  • 747 posts
  • Gender:Male

Posted 18 January 2008 - 12:26 PM

Hi Smurf, thanks for your feedback.
We are working on adding fields to our tabular reports, so more will come with the next versions of the program.

By the way, we have some issues with the fields belonging to items which can have multiple instances, for example network adapters. So we are not sure yet how to output them. This is why they are not available yet to select in the tabular report customization window. Two ways come to mind:

Posted Image

If anyone has an idea which way is better and why (or maybe both, or maybe you can offer a third way), please post your comments here. We will be glad to hear from you.
Softinventive Lab support

#9 mmatheny

mmatheny

    Advanced Member

  • Members
  • PipPipPip
  • 76 posts

Posted 28 January 2008 - 02:29 PM

I prefer the 1st idea - it will be easier to import and manipulate in a spreadsheet. (can delete columns that are not needed)
Mike

#10 Peter Felhofer

Peter Felhofer

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 22 February 2008 - 11:36 AM

Definately Option 2 - no question. Option 1 does not conform to database normalisation and reporting requirements. However, make sure we can add the resource instance name as a column.

I was wondering how to get a report of DHCP vs. Manual settings - this kinda answers it. I've imported the XML files into a database and done it that way for now.


Hi Smurf, thanks for your feedback.
We are working on adding fields to our tabular reports, so more will come with the next versions of the program.

By the way, we have some issues with the fields belonging to items which can have multiple instances, for example network adapters. So we are not sure yet how to output them. This is why they are not available yet to select in the tabular report customization window. Two ways come to mind:

Posted Image

If anyone has an idea which way is better and why (or maybe both, or maybe you can offer a third way), please post your comments here. We will be glad to hear from you.



#11 mmatheny

mmatheny

    Advanced Member

  • Members
  • PipPipPip
  • 76 posts

Posted 22 February 2008 - 02:51 PM

I disagree - the unique field here is the computer name - if you remove that uniqueness (by having more than one record with the same unique identifier), THEN it doesn't conform to database normalization.
Mike




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users