We are implementing an Asset Management software and I have been asked to pull in a lot of information. Here is my query however I am returning the same machine literally thousands of times, is there a way to only list each machine only once?Select T...
We are looking for a report that will show AssetMacAddress changes on switch interface port in the past 24 hours. Similar to the builtin report Switch: Ports but only show Ports that have AssetMacAddress changed in the past 24 hours. Also show previ...
I'm trying to find a field that would indicate the last time the asset record was manually edited. For instance, if you enter some data into Custom4 and save the record, is there a field that updates with the current date/timesamp at that time? Ideal...
Hi,my report shows duplicate entries.I figured out that it is because some assets have more than 1 battery installed.How can I edit the report, so that only one entry for each asset is shown?Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName,...
Hi folks,I am facing the problem, that we have several different reports which still need to be printed out.For that, we export to Excel and then print it.But as the exported report has no title on it, we sometimes swap the reports.So it would be nic...
Hello,I'm looking for a description of what I can filter on at the top of an existing report. Let's say I open a report for an installed program with several versions. At the top of the report I can type a version number and the report filters down...
Hi,Can anyone help? I'm working on a report with criteria:* Is server* Has folder shares* Feature 'FSRM Infrastructure' NOT installedI'm struggling on the feature not installed bit. I think I need something like the example here but I'm new to SQL an...
