LiveReport to pull out login enabled users and their departments on a weekly basis

Atiya_Sultana

Hi All,I have used the below SQL query to get the data for the number of user accounts with Login enabled in Livelink for a particular week or on weekly basis.select userprivileges, firstname, lastname, a.name, datepart(ww,auditdate) from kuaf a, Dauditnew where userprivileges= 2063 and a.ID = DAuditNew.PerformerID group by datepart(ww,auditdate), a.firstname, a.lastname, a.name order by a.nameBut I feel that the result of the above query has missed few users names in the output and i am sure that it should have shown many other users.Could you please help me know whether the above query is correct or not? And if you have any Livereport which meets my requirement can you please pass on. But please make sure it works for SQL 2005.Also, when i use the datepart function in the above query, the day for a week say for example, 45th/46th week of a year gets added for the 45th/46th week of the years 2007 and 2008. Is there any way to separate the weekly data for 2007 and 2008 when the weeks are same without using 'auditdate between 'date' and 'date'' as I have to do this for each single week in two years which is time consuming.Eagerly waiting for your replies.Thanks,Atiya.

Appu_Nair

Userprivileges=2063 that is only one of the many privilgese that has "login Enabled".That number is a bitmask so many other numbers like 1627715 also has 'Login enabled'.So whay you want to do is a bitmask operation on the filed..There are plenty of examples in thid discussion.https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=14433191&objAction=viewor my favoritehttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=14772865&objAction=viewI don't particularly know the grouping part