About Jeff_Henze

Jeff_Henze · 12-27-2019

We are grandfathered in an unlimited asset license, which it seems is restricted in as many ways as possible to 'encourage' us to upgrade to a standard license. So in evaluating things in our asset count, we have 4227 licensed assets in a company of ...

Jeff_Henze · 03-01-2017

I'm a bit baffled by the fact that even though I specifically say I do not want to see records with a tblAssetCustom.Custom2 field like %retired%, I still get items with "Retired" in that field. Here's the report:Select Top 1000000 tblAssets.AssetID,...

Jeff_Henze · 12-08-2016

I’m seeing an unexpected behavior in a report. When I add an additional criterion, instead of dropping 1 record like I expect, it drops almost all of them. The report is to show old systems to be replaced, and I want to drop out those I’ve tagged as ...

Jeff_Henze · 10-27-2016

As I often do, I typed a user's last name in the search bar and lo - they did not exist in LanSweeper. Digging further, even though the user is in AD and active, I see no corresponding record in the AD listing within LanSweeper. Digging further still...

Jeff_Henze · 09-20-2016

I have had this happen before but wrote it off as my mind playing tricks on me; however now I'm certian that it's not all in my head.I changed "custom1" "custom2" etc to different names (such as employee number, assignment date, etc) and set the data...

Jeff_Henze · 03-06-2017

Thanks guys, that was indeed the problem with my query and the solution worked well. It was too many AND ORs for my brain, but incredibly obvious now that you spelled it out.Thanks,-Jeff

Jeff_Henze · 12-15-2016

Answered my own question after a lot of playing around... Apparently [Not Like '%retired%'] means * items that do not have something like 'retired' in them * items that are not NULLSo any fields with a null value in them were also being excluded (man...

Jeff_Henze · 09-01-2016

I forgot about the differences in language (not that I'd recognize them anyway at this point) - I reran it and it ran perfect this time. I noted that my 'where and/or' statement was not working as I hoped so I simplified it. Just in case anyone reads...

Jeff_Henze · 08-30-2016

Ran it - I get an error now though"There was an error parsing the query. [ Token line number = 1,Token line offset = 295,Token in error = Select ]"This went beyond my SQL skills many revisions ago, so I'm not seeing the error but I'm sure it's incred...

Jeff_Henze · 08-30-2016

<edit> Thanks - it works *except* that I no longer see any info under "Assigned Employee". I'm trying to figure out why that is the case. All the other stuff seems to work great - no duplicates anymore.

User Statistics

User Activity

Active directory workstations and users - count toward asset total? Merge?

Unexpected results on where statement

Unexpected results with added criteria

"random" AD User Records not showing up in LS

Custom field names and new reports gone

Re: Unexpected results on where statement

Re: Unexpected results with added criteria

Re: Avoiding duplicate assets when doing a left-join to AD users

Re: Avoiding duplicate assets when doing a left-join to AD users

Re: Avoiding duplicate assets when doing a left-join to AD users