Hello,

Looking to use SmarterStats Free Edition (Version 10.5.5751)  to pull details for sub portals; link below suggest use of the TabId for this purpose. 

In reviewing a DNN SQL query, it maybe that PortalId is the way to go.  Does anyone have experience or guidance in this matter?

SELECT [TabID]
,[PortalID]
,[TabName]
,[IsVisible]
,[ParentId]
,[DisableLink]
,[Title]
,[Description]
,[KeyWords]
,[IsDeleted]
,[Url]
,[ContentItemID]
,[Level]
,[TabPath]
FROM [Mysite].[dbo].[Tabs]

 

Snipped example review shows that all three entries belong to the same sub portal as represented by the PortalId

TabId PortalId Tabname

1036 12 Activity Feed

1037 12 Admin

1038 12 Search Results

 

Hello,

Are you referring to:

/Mysite/App1
/Mysite/App2

Michael

hello,

yes, that will work on a domain basis.

Customer not structured that way.

Have:
www.mydomain.com
- App1
- App2
- App3

Looking to get counts for each App. App is a focused area of intrest. User(s) of App1 may not have intrest in App2 or App3.

Tabid seem to be many to one relationship with PortalId.

Thanks,

Michael