About GMFDE

GMFDE · 11-01-2019

I have a report that lists the systems that have not logged on in the last 30 days. I need to find a way to limit this to show just the last log on event. Below is what I have so far. Any help would be appreciated. Select Distinct Top 1000000 tblAsse...

GMFDE · 11-02-2018

Sorry, I had to use that subject line because there is an unanswered post from someone else with the subject line I wanted to use and this forum software is set to prevent duplicate posts. Silly really.To the point. I have been working on a report to...

GMFDE · 09-07-2018

I have a chart report that works well but I want to refine it a little bit. The report queries a group of workstations, determines what version of java is installed and presents that in a bar chart with totals for each version. Currently, there are 3...

GMFDE · 09-06-2018

What is the proper syntax for this operation? I have tried the following:Where tblAssets.AssetName = In ('asset name 1', 'asset name 2', 'asset name 3', 'asset name 4', 'asset name 5')orWhere tblAssets.AssetName = In "'asset name 1, 'asset name 2'I h...

GMFDE · 01-12-2016

I've got a chart report that lists all the browsers by version. What I want is to combine the different versions so that the X axis is simply1. Internet Explorer 47212. Firefox 2753. Chrome 744. Opera 12As it stands now, the chart has about 35 entrie...

GMFDE · 11-25-2019

bumpGMFDE wrote:I have a report that lists the systems that have not logged on in the last 30 days. I need to find a way to limit this to show just the last log on event. Below is what I have so far. Any help would be appreciated. Select Distinct Top...

GMFDE · 11-06-2018

RC62N wrote:The problem you're running into is down to the phrasing of your condition. The contents of your WHERE clause is evaluated for each software name. When you sayWhere tblSoftwareUni.softwareName Like '%java 7%' And tblSoftwareUni.softwareNa...

GMFDE · 09-10-2018

RC62N wrote:Java's a bit of an odd duck of an example to use since the value of softwareName includes an update number that's associated with the full version number, but let's give this a shot.On the other hand, if you just want the major version in...

GMFDE · 09-10-2018

I'm sure it's just a syntax error on my part but when I run the below, I get "This report has no results!" Again, I'm sure that I'm using your code incorrectly. I appreciate your patience but if you wouldn't mind, a pointer in the right direction wou...

GMFDE · 09-07-2018

RC62N wrote:LEFT(tblSoftware.softwareVersion, CHARINDEX('.', tblSoftware.softwareVersion)-1)If there's a chance that some of what you're reporting on won't have a decimal point in the softwareVersion value, you'll need to make it conditional.SQL Serv...

User Statistics

User Activity

Limit report to only include last logon time

Non-Unique SW installations per system

Chart report grouping criteria

tblAssets.AssetName: how to add multiple asset names

Trouble nailing down a chart

Re: Limit report to only include last logon time

Re: Non-Unique SW installations per system

Re: Chart report grouping criteria

Re: Chart report grouping criteria

Re: Chart report grouping criteria