ServiceDesk

 View Only
  • 1.  Filtering Locations

    Posted May 29, 2013 01:14 AM

    Hi All,

    We have 559 Location defined in the SMP which get picked up by ServiceDesk and shown in various feeder forms.

    Due to how these location resources are created many are not real locations but can't be deleted out from the SMP.

    In the Advanced Feeder Form I can see the GetAllLocationsComponent is getting the location details from the SMP but I can't see any way modify it.  

    I'd like to use a specific SMP report to filter down the locations.  Is this possible?  Ideally I'd do it in one place that affected all areas of ServiceDesk where locations are offered in forms.



  • 2.  RE: Filtering Locations
    Best Answer

    Broadcom Employee
    Posted May 29, 2013 09:51 AM

    Actually the GetAllLocations component is simply calling a report from the SMP. The report is called 'All Locations'. You can modify the report to return the filtered results you desire.

    All the reports that ServiceDesk uses from the SMP can be found in Reports\Service and Asset Management\ServiceDesk. The draw back is that most, if not all, of these reports are hidden and read only. You can use the below SQL query to make the reports editable. This query needs to be ran against your SMP database(Symantec_CMDB by default)

    UPDATE Item
    SET Attributes = 0
    WHERE Guid IN (
    SELECT ItemGuid FROM ItemFolder
    WHERE ParentFolderGuid = '99338db4-ad72-4691-af34-719c104521da')
     


  • 3.  RE: Filtering Locations

    Posted May 29, 2013 11:05 PM

    Wow - what a perfect answer!  Thanks very much this is exactly what I needed.  Location list is now down to  359 entries.