spUserNetworking_GetAdminCounts

  CREATE PROCEDURE [dbo].[spUserNetworking_GetAdminCounts]
  AS
  BEGIN

  DECLARE @TOTAL int
  DECLARE @INACTIVE int
  DECLARE @DELETED int
  DECLARE @LOCKED int
  DECLARE @ONLINE int

  SELECT @TOTAL = count(*) FROM NetAccount

  SELECT @INACTIVE = count(*) FROM NetAccount WHERE Datediff(day, dateadd(day,-30,getutcdate()),  UpdateDate) < 0 AND Deleted = 0

            SELECT @DELETED = count(*) FROM NetAccount WHERE Deleted = 1

            SELECT @LOCKED = count(*) FROM NetAccount WHERE LockedOut = 1

            SELECT @ONLINE = count(*) FROM NetAccount WHERE OnlineStatus = 1 AND Deleted = 0



            DECLARE @TOTALGROUPS int
            DECLARE @INACTIVEGROUPS int
            DECLARE @DELETEDGROUPS int
            DECLARE @LOCKEDGROUPS int

            SELECT @TOTALGROUPS = count(*) FROM NetGroup

            SELECT @INACTIVEGROUPS = count(*) FROM NetGroup ng WHERE (Select Count(*) FROM NetGroupRelation ngr WHERE ngr.NetGroupID = ng.ID) <= 1

        SELECT @DELETEDGROUPS = count(*) FROM NetGroup WHERE Deleted = 1

        SELECT @LOCKEDGROUPS = count(*) FROM NetGroup WHERE LockedOut = 1


        DECLARE @SENTMESSAGES int
        DECLARE @RECEIVEDMESSAGES int
        DECLARE @DELETEDMESSAGES int


        SELECT @SENTMESSAGES = Count(*) FROM [Message] WHERE SentDate IS NOT NULL AND DELETED = 0 --Sent Messages
        SELECT @RECEIVEDMESSAGES = Count(*) FROM [Message] WHERE SentDate IS NULL AND DELETED = 0 --Received Messages
        SELECT @DELETEDMESSAGES  = Count(*) FROM [Message] WHERE DELETED = 1 --Deleted Messages


        SELECT
        ISNULL(@TOTAL,0) 'Total',
        ISNULL(@INACTIVE,0) 'Inactive',
        ISNULL(@DELETED,0) 'Deleted',
        ISNULL(@LOCKED,0) 'Locked',
        ISNULL(@ONLINE,0) 'Online',
        ISNULL(@TOTALGROUPS,0) 'TotalGroups',
        ISNULL(@INACTIVEGROUPS,0) 'InactiveGroups',
        ISNULL(@DELETEDGROUPS,0) 'DeletedGroups',
        ISNULL(@LOCKEDGROUPS,0) 'LockedGroups',
        ISNULL(@SENTMESSAGES,0) 'SentMessages',
        ISNULL(@RECEIVEDMESSAGES,0) 'ReceivedMessages',
        ISNULL(@DELETEDMESSAGES,0) 'DeletedMessages'


        END