Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Untag as favorite
Quickfix report for computer doesn't sort properly by InstalledOn date
Options
Previous Topic Next Topic
sebouh
#1 Posted : Friday, April 16, 2010 6:18:32 PM

Rank: Premium user

Groups: Premium Users
Posts: 89
Location: New Jersey
Pick any computer, navigate to the Quickfix report page and then click the InstalledOn column heading to sort by the date the patch was installed. I don't know what order it sorts it in, but it isn't date or text. See sample image.

Sebouh
sebouh attached the following image(s):
ls4.gif
Back to top
sebouh
#2 Posted : Wednesday, April 21, 2010 3:58:14 PM

Rank: Premium user

Groups: Premium Users
Posts: 89
Location: New Jersey
This doesn't appear to have been fixed in the released version of Lansweeper 4.0. Can I assume it will be addressed in a future release?
Back to top
Lansweeper
#3 Posted : Wednesday, April 21, 2010 4:13:15 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,369
sebouh wrote:
This doesn't appear to have been fixed in the released version of Lansweeper 4.0. Can I assume it will be addressed in a future release?

Yes together with another date sorting problem.
Back to top
sebouh
#4 Posted : Wednesday, May 12, 2010 7:00:07 PM

Rank: Premium user

Groups: Premium Users
Posts: 89
Location: New Jersey
This doesn't appear to have been fixed yet, correct?
Back to top
Lansweeper
#5 Posted : Wednesday, May 12, 2010 7:22:11 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,369
sebouh wrote:
This doesn't appear to have been fixed yet, correct?

Indeed, it's on the list for next update.
Back to top
sebouh
#6 Posted : Wednesday, May 12, 2010 7:22:53 PM

Rank: Premium user

Groups: Premium Users
Posts: 89
Location: New Jersey
Thanks
Back to top
Lansweeper
#7 Posted : Wednesday, May 19, 2010 11:38:07 AM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,369
This can't be fixed, the reason is that the information is stored as a string and the date format is not always the same for each patch.
Sometimes dd/mm/yyyy, sometimes mm/dd/yyyy
it's also sometimes empty or a non-date
Back to top
sebouh
#8 Posted : Monday, May 24, 2010 7:54:42 PM

Rank: Premium user

Groups: Premium Users
Posts: 89
Location: New Jersey
Even if the informatin is stored in a string, clicking the column title should at least sort the items by whatever is entered in the string. It doesn't even do that. It just doesn't appear to do anything.

Sebouh
Back to top
Lansweeper
#9 Posted : Monday, May 24, 2010 8:44:04 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,369
The problem is not really that it's stored as a string, but we noticed that dd/mm and mm/dd are sometimes mixed, even for the same computer.
Back to top
sebouh
#10 Posted : Monday, May 24, 2010 9:06:33 PM

Rank: Premium user

Groups: Premium Users
Posts: 89
Location: New Jersey
Even with mm/dd and dd/mm varying, I would like to sort this by whatever data is in this nvarchar field. Occasionally I'd like to determine when the last batch of updates were installed. It would be nice if the items with the same date were grouped together in the list.

Look at the attached screen shot. Even though the InstalledOn column is what I'm sorting by it looks like it is sorted by the HotFixID. Bug?

Sebouh
sebouh attached the following image(s):
ls14.gif
Back to top
Users browsing this topic
Guest
Untag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba