tblAssets
Hitrying to create a report with tblAssets and tblUsers. I select various options in tblAssets and I select Fullname in tblUsers but when I run the report, the section does not populate with full name details. Any advice please?
Topics in this forum
Helpdesk Report with htblnotes - note ntext
I have a Helpdesk report that shows which tickets were closed in the last X days. I have it sorted by user department. The report works great as is below. Select Top 1000000 htblusers.department As Department, htblticket.ticketid, '#' + Cast(htblti...
Resolved! Problem with multiple excludes in report
i try to exclude few values from report but it still contains them, can any1 tell me what i'm doing wrong ?:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssetC...
Which field to change this to?
What change do I need to make so this report shows the initial ticket description (the first email they write in to describe a problem) in the Resolution column, as opposed to the final ticket note? I will change the column name to initial issue. Se...
Specific IP subnet report
Dear Support,I want to create a report for specific subnet.For example: 10.10.1.0/24 reportKindly help me.
Resolved! text file found and/or application installed
Hi,We are in the process of rolling out an application. For some reason the installer is unstable and often fails. Because if this we would need a way to find these computers.As the last step in the installation process a .txt file is created in the ...
Suspended Windows Sessions
Does anyone know of a way to have Lansweeper scan for and report suspended windows sessions over a certain age/length?
Resolved! Error: Report not allowed.
Hi,I have "Administrator+Agent" permissions, What other additional permissions needed to view the report? Where to place them? Code reportSelect Top 1000000 tblConfigLog.Date, Case tblConfigLog.ActionID When 1 Then 'change' When 2 Then '+' When 3...
