Prev
Next
Forums Performance Management Smart Notification

Smart Notification GUID

 3 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
Dennis Amory
Basic Member
Posts: 10
Basic Member
2/27/2012 6:01 PM
    What's the best way of knowing exactly which Smart Notification (SN) is tied to a dashboard link? In other words, If I edit the dashboard link, when I go to the URL text box (under the Main tab), I can see a value like this: FSRemote?fsid=SN:SN-Smart Notification:12992&guid=z64db9132:12c9753609c:-7fd3:18a97.
    How do I reference this GUID back to an actual SN to determine which SN is actually being run when I click on that dashboard link?
    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
    2/27/2012 7:05 PM
      12992 is the actual ID of your smartnotification. Assuming you dont have multiple instances of SN in the same environment, you can find this by opening SmartNotification Administration console from the Tools dashboard, hover over each of your Notifications from the Notification section and keep an eye on the status bar in IE. As you roll over each name youll see a URL appear. The beginning of that URL should be something like http://lbiserver:port/lsn/servlet/com.lawson.lsn.uiengine.ShowDetails?objid=SN_ID&objtype=3

      Where SN_ID is 12992.

      Now judging by your ID #, youve either got A LOT of notificaitons or youve just imported and then deleted a lot of notifications. If its the former, a SQL query on the SN database is probably more efficient. 

      
SELECT *
FROM dbo.ENPBATREE 
WHERE ENTRYCATEGORY = (SELECT CATEGORYID FROM dbo.ENPCATEGORIES WHERE CATEGORYDESC = 'SSS_ALERT')
AND TREEENTRYID = 12992


      This was written on a system that has about 20 notifications (hense the SELECT *), please take the appropriate precautions for your environment before running this.

      hth
      Matt
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      Matthew Nye
      Veteran Member
      Posts: 514
      Veteran Member
      2/27/2012 7:06 PM
        Seems there is an issue with the post, its encoding part of that script. it should be WHERE CATEGORYDESC = 'SSS_ALERT' at the end of the subselect.
        If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
        Dennis Amory
        Basic Member
        Posts: 10
        Basic Member
        2/27/2012 7:47 PM
          Thanks, Matt. I DO have alot of SN's, so I'm gonna go with the SQL Select statement. It works great! Thanks !!