Filter by Computer Groups in Excel Connector

Reporting
1

(imported topic written by Shembop91)

I love the Excel connector, but have come across something that I can’t seem to do (or am blind)

Is there a way to filter by Computer Group Membership?

2

(imported comment written by Shembop91)

Oh, and while I’m at it, how do I actually filter by Date? as in computers who have reported back in the last X amount of days.

3

(imported comment written by BenKus)

Hey Shembop,

I don’t believe the Excel Connector currently has these capabilities unfortunately… For the second question, you would have to get tricky with Excel logic to convert our date string into an Excel recognized date string so you could filter/sort. I don’t know how exactly to get a date and time in Excel, but you could use something like this:

=DATEVALUE(MID(D5,6,20))

(where D5 is a BigFix time string such as “Sun, 20 Jun 2010 02:19:55 +0000”)

Ben