Customer Report Help, List of Workstations and Date Certain Software Removed
Hi, I am looking for a report that will list a workstation, user assigned to it, and date a specific software was removed. Looking to generate a report that will list all workstations/servers on when we uninstalled office 2000. Also would like one that shows when a specific software was installed. Thanks,Dave
Loss of Formatting
When a technician or a requestor enters information into the Description field and formats it using the built in text tools in ServiceDesk, once the request is submitted the formatting is lost (such as if you change the text to blue and bold it changes it back to black but keeps the bold.) Same goes for when a technician enters a resolution and uses the text editor to change the text (such as to make something bold and red so the requester will see it when the automated e-mail is generated). Any
pls help on SQL statement : number of times per installed software per department
Hello Could anybody give me please some help on a query which reports me the number of times a software has been installed in a department. Here is the list of the installed softwares. How to extend the query whith the information of the department? SELECT Max(SoftwareList.SOFTWARENAME) "Software",Max(SoftwareList.FILEVENDOR) "Manufacturer",COUNT(DISTINCT(SoftwareInfo.SOFTWAREINFOID)) 'Installed' FROM SoftwareGroupMember LEFT JOIN SoftwareList ON SoftwareGroupMember.PARENTSOFTWAREID=SoftwareList.SOFTWAREID
Reporting on Tasks
Hi All, I was wondering if anyone knows or can point me in the right direction on how to report on completed tasks by technician? Ideally i would like a pie chart on how many tasks each technician has completed/closed for the previous month Included in
Generate report having "response timings"
Site field shown in requests when no sites configured
In v7508, the "Site" field is shown in the request template and request view page even when a site is not configured. This field cannot be set to hidden in the request template configuration, even in the requester view. I did not see this listed in the know issues, so I apologize if this has already been reported.
Audit report that shows Software Type changes
Hi Im running 7508 on a MSSQL Anyone have a report that shows changed to Software Type in the last week ? We have a operation center that weekly move unidentified software into categorizes. I need a report that shows what changed they made. Anyone that can help me here ?
Report showing ALL equipment, devices, and printers
Does anyone know of a way to report counts of ALL pieces of equipment IT could touch....all servers, workstations, routers, switches, and printers (networked AND not networked)? I need a comprehensive list of absolutely every piece of equipment in the system, but can't seem to find anything that does that....and yes, I even need non-networked/locally-shared printers. We calculate allowed number of FTEs based on equipment/nodes touched.
Change Reports
Standard Change Reports do not classify change type in sync with customizable color coding in Change Type. Is there a way to modify.
Which workstations do NOT have specific software installed
Hi, I'm trying to figure out how to run a report that will tell me which workstations do NOT have specific application(s) installed. Thanks,
Reports: Custom Query needed for several software apps to include Last Scanned Date
Still using 6.013 (long story), I have been tasked with generating several reports that are software specific against assets but it must include last scanned date. Using the Inventory GUI, drilling down to the particular piece of software than exporting to PDF does not show this so looking at a custom query as the scanned date is not an option within Reports. Is anyone able to advise if this is acheivable? Looking to export to a csv file; (defined) Software Name Software Type Owner Workstation
Requestor with No Assets
I have been asked to write a report showing all requestors (users) without an asset assigned to them. I think what the end goal is - to find out which requestors haven't had their workstations scanned. Any ideas? Thanks!
Cannot update any asset SD 7.5
Hello, I am having a problem when trying to update any asset. I am receiving the error you can see in the attached screen dump Error: -1,246,871,184,731 I cannot edit any asset!, even if it doesn't have any relationship SP+ 7.5 build 7504 - tested with 7508 and the same results IE 6 and 8 SQL Server 2000 Win XP SP 2 Thanks in advance
Is there a way to get count of the records in report
I am trying to create a Custom report to get the number of record under each groups (grouped by the Request status). I see that the 'Total records' field appears when the report is run. Is there any way to tweak the query so as to see the subtotals under each group. i.e., the number of records under each group. (eg: No of records under <group1> is 5) Thx, Jan
Purchase Order Report to Show Items and QTY
Just wanted to know if we can print detailed purchase order reports. At the moment it looks like the reports will show everything but whats being ordered, qty and who from. I think this is a big part of the order and should be able to printed on the report, especially since i want the user to email me weekly purchase order reports outlining all the orders for the week showing what they are for, what the items are, cost ect. At the moment i have added an extra feild to the PO form which is great and
Software report on Workstations not with the disposed status
Hi, I will like to be able to run a report similar to the 'Software Reports - Purchased Vs Installed software' but for all workstations except 'disposed' ones. At the moment this report include installed software on disposed workstations also. I have tried to add (Resource.RESOURCESTATEID <> 5) to the query below but did not work. SELECT MAX(SoftwareList.SOFTWARENAME) 'Software',MAX(SoftwareList.FILEVENDOR) 'Manufacturer',MAX(SoftwareType.SOFTWARETYPE) 'Type',MAX(SoftwareCategory.SOFTWARECATEGORY)
email problems reports
I am having difficulty with sending planned reports. the emails are empty. no reports are attached. Doesnt matter if you select HTML or PDF (which is perfered) I have tested various things, but cant fint the trick in the box of magic. Can someone help me out here? ...... please.....
Purchse Order Form
Hi SD+ Team, can i change the layout of the order form? If it's possible, where an how? And another question: When i mail the order to our reseller he receive a html-embedded mail. The mail-windows gives me the option to mark the checkbox "pdf as attachement" - but there's no pdf-file. Greetings Albae
Report
How can I get a report with all asset on it including Asset Components?
Custom report "All hardware by department"
Hello, I am trying to create a custom report with the following in it: - All hardware (not only workstations & laptops) including monitors, printers, routers, etc. - sorted by site & department As far as I can see we can only select a report with all Workstations in it. I know I can make a custom report but I am not a programmer so some help would be appriciated. My finance department asked me for a list of all hardware by site. How can I get a quick and clean list of all the hardware that
Wrong CPU detected in Asset reports
Intel(R) Core(TM)2 Duo CPU P8600 @ 2.40GHz are being detected as Intel Pentium III Xeon processor in Lenovo Thinkpad T400's.
How to get Subtotals(record count) in a Customised Report
Hi. Is it possible to get the subtotals (count of records under each group) in a customised report. I am trying to fetch the details as below and is trying to get the record count under the groups 'Closed', 'Open' etc. (Something like a matrix to get the counts,) Priority Closed (P4) Low (P4) Low Open (P3) Medium (P4) Low (P3) Medium (P3) Medium (P3) Medium Thnx, SreeJan
report showing summary info of workstations
Hello, i have been trying to come up with a custom report which will show me all the info i have availalbe about a particular asset; inlcluding what is in the custom fields. currently the 'computers by domain' fits the bill pretty good, however there is no option to select my additional fields. can you please help with this? thank you very much.
using microsoft SRS reporting
How do you calculate the dates in Microsoft SQL reporting services? I know how to setup the formula in crystal based on this article http://writer.zoho.com/public/13706/27397 but I was wondering if anyone had used the MS SRS software to run reports using dates. Thanks
Historic View showing level of Open Requests
I am after a report that shows the level of open requests over the last six weeks, Is there a pre-built report to do this or can anyone give me an idea on how to produced it? I can produce a report showing how many have been created but non that gives me the level of requests open on a date. Thanks in Advance Shaun
Level of open requests reports over a period of time
I am after a report that I can produce by day over the last six weeks showing the level of open requests. Is this possible? Thanks in Advance Shaun
"Sort By" very useful for Reports
Hello, Is it possible to add the "Sort By" option when you are creating or editing reports? We really need this option available as we have very large reports that we would like to have organized from the source rather than organizing the data from Excel after the report is generated. Thanks, Mike
Impact Details not available in reports
I'm suprised that I don't find Impact Details available in the normal list of available columns in a Tabular Report. I'm sure I could get it out of a query report, but I loose some capabilities, such as graphing, in a query report. I'm running build 7504 - this isn't fixed in a later build, is it?
Unable to report on "pick list" custom fields
We have three custom fields in our default template. Two of them are "Single-line" text fields; the third is a "Pick List" text field. When we go to the reporting tool, we do not have our custom "Pick List" text field as an available field to report on. However, we can report on the two custom "Single-line" text fields. Please issue a bug fix to address this issue. Thanks- Marc
Active Directory Import Problems post 7506 upgrade!
Importing from AD is not possible post 7506 upgrade. When an import attempt is made the window just hangs. Is this fixed in 7507? I am reluctant to move to 7507 as I have read so many bad reports!
Verbiage for Report: Workstation and Last Logged In User
There used to be a post in the old Forums with the SQL verbiage on how tpo do this - sadly, I didn't put it in the Solutions section of ServiceDesk (Oh, the irony). Can anyone give a point in the right direction? Thanks - M.
Expanded overdue requests report
Management wants to see a report (stacked bar graph actually which I can do outside SDP if I can get the data) with the X-axis showing number of days overdue (i.e. 10 bars showing 1,2,3,4,5,6,8,10,12,>=14 overdue) and Y-axis with number of requests. The stacks will be by priority. The MSSQL code with those three columns should be all I need to take care of the rest. Thanks in advance for your help.
Query Report Error - ( run smooth on mssql)
HI, After upgrade to new 7.5 some of Request has a blank department field so I am trying to build Query Report to get dept name from master department (departmentdefinition) but the query given below will not run. im using mssql SELECT dbo.WorkOrder.WORKORDERID, dbo.WorkOrder.REQUESTERID, dbo.WorkOrder.DEPTID, dbo.DepartmentDefinition.DEPTNAME AS Depratment, dbo.CategoryDefinition.CATEGORYNAME AS Category, dbo.SubCategoryDefinition.NAME AS SubCategory, dbo.ItemDefinition.NAME
DATE_FORMAT
I have the following query. I want to format the Acquisition Date to display in UK format without showing the time. For example, today would be 27/05/2009. SELECT resFields.UDF_CHAR2 'Asset Location',resource.ASSETTAG 'Asset Tag', resource.SERIALNO 'Serial Number',product.COMPONENTNAME 'Product',LONGTODATE(resource.ACQUISITIONDATE) 'Acquisition Date', resourcecost.cost 'Purchase Price' FROM Resources resource LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID LEFT