June 1, 2016 at 4:20 am
Good day Experts,
I am not an expert in sql please help.
I have a sql agent job that feeds information about clients computers into a table xxxx once a week.I have a report that runs monthend pulling information from table xxxx .I have a query that must run within a report showing (sum) number of clients that were supported that month and previous month.I want each machine to be counted once even though the job runs once a week x4.
This is the query i am using but my problem is each machine is counted more than once therefore i end up with thousands on supported clients on my report.
select
left(convert(nvarchar,a.CaptureDate,102), 4) + '.' + substring(convert(nvarchar,a.CaptureDate,102), 6,2) as YearDate,
left(datename(month,a.CaptureDate),3) + '-' + left(convert(nvarchar,a.CaptureDate,102), 4) as MonthDate,
a.SEPStatus,
a.IsAtEnd,
SUM(a.NoOfClients) as NoOfClients
from PNS_Sect_6_SiteSEPStatus as a
where
CaptureDate between convert(nvarchar,dateadd(day,-datepart(day,@DateVar)+1,DATEADD(month,-5,@DateVar)),102) and convert(nvarchar,dateadd(day,-datepart(day,@DateVar)+1,DATEADD(month,1,@DateVar)),102)
group by
left(convert(nvarchar,a.CaptureDate,102), 4) + '.' + substring(convert(nvarchar,a.CaptureDate,102), 6,2),
left(datename(month,a.CaptureDate),3) + '-' + left(convert(nvarchar,a.CaptureDate,102), 4),
a.SEPStatus,
a.IsAtEnd
order by YearDate, a.IsAtEnd, a.SEPStatus
June 1, 2016 at 5:06 am
Difficult to visualise without any table DDL or sample data, but what you want is a snapshot as at the end of last month and the end of the previous month of how many computers there were with each SEPStatus and IsAtEnd - is that right? If so, you don't need to do a group by - just get the information for the end of each of those two months. If you provide table DDL in the form of a CREATE TABLE statement, sample data in the form of INSERT statements and expected results based on that sample data, I'll show you how to do that.
John
June 1, 2016 at 5:33 am
You could probably treat it like versioned data and only retrieve the latest row of each type. I have example queries in this article [/url]on how to do this.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 1, 2016 at 5:44 am
To assist others, here is the query once again, formatted for readability:
SELECT LEFT(CONVERT(NVARCHAR, a.CaptureDate, 102), 4) + '.' + SUBSTRING(CONVERT(NVARCHAR, a.CaptureDate, 102), 6, 2) AS YearDate
, LEFT(DATENAME(MONTH, a.CaptureDate), 3) + '-' + LEFT(CONVERT(NVARCHAR, a.CaptureDate, 102), 4) AS MonthDate
, a.SEPStatus
, a.IsAtEnd
, SUM(a.NoOfClients) AS NoOfClients
FROM PNS_Sect_6_SiteSEPStatus AS a
WHERE CaptureDate BETWEEN CONVERT(NVARCHAR, DATEADD(DAY, -DATEPART(DAY, @DateVar) + 1, DATEADD(MONTH, -5, @DateVar)), 102)
AND CONVERT(NVARCHAR, DATEADD(DAY, -DATEPART(DAY, @DateVar) + 1, DATEADD(MONTH, 1, @DateVar)), 102)
GROUP BY LEFT(CONVERT(NVARCHAR, a.CaptureDate, 102), 4) + '.' + SUBSTRING(CONVERT(NVARCHAR, a.CaptureDate, 102), 6, 2)
, LEFT(DATENAME(MONTH, a.CaptureDate), 3) + '-' + LEFT(CONVERT(NVARCHAR, a.CaptureDate, 102), 4)
, a.SEPStatus
, a.IsAtEnd
ORDER BY YearDate
, a.IsAtEnd
, a.SEPStatus;
As an aside, note that the way in which you have coded the CaptureDate filter in the WHERE clause is likely to cause performance issues over large datasets.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 1, 2016 at 6:39 am
Hi John,
I am glad you know exactly what i want to archieve.Below is the table defination and the data.Thanks !!
CREATE TABLE [dbo].[PNS_Sect_6_SiteSEPStatusSnapshot](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Site] [nvarchar](100) NULL,
[CaptureDate] [datetime] NULL,
[SEPStatus] [varchar](100) NULL,
[NoOfClients] [int] NULL,
[CreatedOn] [datetime] NULL,
[IsAtEnd] [bit] NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
--------------------------------------------
Insert into dbo].[PNS_Sect_6_SiteSEPStatusSnapshot](
ID,SITE,CaptureDate,SepStatus,NoOfclients,CreatedOn,IsAtEnd)
Values(873landau2016-05-26 21:00:01.370Drop Link02016-05-26 21:00:01.370NULL
874landau2016-05-26 21:00:01.370Offline02016-05-26 21:00:01.370NULL
875landau2016-05-26 21:00:01.370Total3 2016-05-26 21:00:01.3701
876landau2016-05-26 21:00:01.370Up To Date32016-05-26 21:00:01.370NULL
865kriel 2016-05-26 21:00:01.350Drop Link02016-05-26 21:00:01.350NULL
866kriel 2016-05-26 21:00:01.350Offline02016-05-26 21:00:01.350NULL
867kriel 2016-05-26 21:00:01.350Total16 2016-05-26 21:00:01.3501
868kriel 2016-05-26 21:00:01.350Up To Date162016-05-26 21:00:01.350NULL
869RLT 2016-05-26 21:00:01.200 Drop Link12016-05-26 21:00:01.200NULL
870RLT 2016-05-26 21:00:01.200Offline02016-05-26 21:00:01.200NULL
871RLT 2016-05-26 21:00:01.200Total8 2016-05-26 21:00:01.2001
872RLT 2016-05-26 21:00:01.200Up To Date72016-05-26 21:00:01.200NULL
857Klein kopje2016-05-26 21:00:00.783Drop Link02016-05-26 21:00:00.783NULL
858Klein kopje2016-05-26 21:00:00.783Drop Link02016-05-26 21:00:00.783NULL
859Klein kopje2016-05-26 21:00:00.783Offline02016-05-26 21:00:00.783NULL
860Klein kopje2016-05-26 21:00:00.783Offline02016-05-26 21:00:00.783NULL
861Klein kopje2016-05-26 21:00:00.783Total3 2016-05-26 21:00:00.7831
862Klein kopje2016-05-26 21:00:00.783Total13 2016-05-26 21:00:00.7831
863Klein kopje2016-05-26 21:00:00.783Up To Date32016-05-26 21:00:00.783NULL
864Klein kopje2016-05-26 21:00:00.783Up To Date132016-05-26 21:00:00.783NULL
845Isibonelo2016-05-26 20:30:01.470Drop Link02016-05-26 20:30:01.470NULL
846Isibonelo2016-05-26 20:30:01.470Offline02016-05-26 20:30:01.470NULL
847Isibonelo2016-05-26 20:30:01.470Total8 2016-05-26 20:30:01.4701
848Isibonelo2016-05-26 20:30:01.470Up To Date82016-05-26 20:30:01.470NULL
853New Vaal2016-05-26 20:30:01.203Drop LinkNULL2016-05-26 20:30:01.203NULL
854New Vaal2016-05-26 20:30:01.203OfflineNULL2016-05-26 20:30:01.203NULL
855New Vaal2016-05-26 20:30:01.203Total0 2016-05-26 20:30:01.2031
856New Vaal2016-05-26 20:30:01.203Up To DateNULL2016-05-26 20:30:01.203NULL
849 New Denmark 2016-05-26 20:30:00.880Drop Link02016-05-26 20:30:00.880NULL
850New Denmark2016-05-26 20:30:00.880Offline12016-05-26 20:30:00.880NULL
851New Denmark2016-05-26 20:30:00.880Total4 2016-05-26 20:30:00.8801
852New Denmark2016-05-26 20:30:00.880Up To Date32016-05-26 20:30:00.880NULL
829Greenside2016-05-26 20:00:03.560Drop Link02016-05-26 20:00:03.560NULL
830Greenside2016-05-26 20:00:03.560Offline62016-05-26 20:00:03.560NULL
831Greenside2016-05-26 20:00:03.560Total19 2016-05-26 20:00:03.5601
832Greenside2016-05-26 20:00:03.560Up To Date132016-05-26 20:00:03.560NULL
837mafube2016-05-26 20:00:03.070Drop LinkNULL2016-05-26 20:00:03.070NULL
838mafube2016-05-26 20:00:03.070OfflineNULL2016-05-26 20:00:03.070NULL
839mafube2016-05-26 20:00:03.070Total02016-05-26 20:00:03.0701
840mafube2016-05-26 20:00:03.070Up To DateNULL2016-05-26 20:00:03.070NULL
841 Goedehoop South2016-05-26 20:00:01.583Drop Link02016-05-26 20:00:01.583NULL
842Goedehoop South2016-05-26 20:00:01.583Offline 212016-05-26 20:00:01.583NULL
843Goedehoop South2016-05-26 20:00:01.583Total21 2016-05-26 20:00:01.5831
844Goedehoop South2016-05-26 20:00:01.583Up To Date02016-05-26 20:00:01.583NULL
833zibulo2016-05-26 20:00:01.467Drop Link1 2016-05-26 20:00:01.467NULL
834zibulo2016-05-26 20:00:01.467Offline5 2016-05-26 20:00:01.467NULL
835zibulo2016-05-26 20:00:01.467Total23 2016-05-26 20:00:01.4671
836zibulo2016-05-26 20:00:01.467Up To Date17 2016-05-26 20:00:01.467NULL
825Goedehoop North2016-05-26 20:00:00.757Drop Link12016-05-26 20:00:00.757NULL
826Goedehoop North2016-05-26 20:00:00.757Offline62016-05-26 20:00:00.757NULL
827Goedehoop North2016-05-26 20:00:00.757Total21 2016-05-26 20:00:00.7571
828Goedehoop North2016-05-26 20:00:00.757Up To Date142016-05-26 20:00:00.757NULL
817kriel2016-05-19 21:00:01.673Drop Link02016-05-19 21:00:01.673NULL
818kriel2016-05-19 21:00:01.673Offline02016-05-19 21:00:01.673NULL
819kriel2016-05-19 21:00:01.673Total162016-05-19 21:00:01.6731
820kriel2016-05-19 21:00:01.673Up To Date162016-05-19 21:00:01.673NULL
809RLT2016-05-19 21:00:01.080Drop Link12016-05-19 21:00:01.080NULL
810RLT2016-05-19 21:00:01.080Offline02016-05-19 21:00:01.080NULL
811RLT2016-05-19 21:00:01.080Total82016-05-19 21:00:01.0801
812RLT2016-05-19 21:00:01.080Up To Date72016-05-19 21:00:01.080NULL
821landau2016-05-19 21:00:00.710Drop Link02016-05-19 21:00:00.710NULL
822landau2016-05-19 21:00:00.710Offline02016-05-19 21:00:00.710NULL
823landau2016-05-19 21:00:00.710Total32016-05-19 21:00:00.7101
824landau2016-05-19 21:00:00.710Up To Date32016-05-19 21:00:00.710NULL
813Klein kopje2016-05-19 21:00:00.600Drop Link02016-05-19 21:00:00.600NULL
814Klein kopje2016-05-19 21:00:00.600Offline02016-05-19 21:00:00.600NULL
815Klein kopje2016-05-19 21:00:00.600Total132016-05-19 21:00:00.6001
816Klein kopje2016-05-19 21:00:00.600Up To Date132016-05-19 21:00:00.600NULL
797Isibonelo2016-05-19 20:30:01.900Drop Link02016-05-19 20:30:01.900NULL
798Isibonelo2016-05-19 20:30:01.900Offline02016-05-19 20:30:01.900NULL
799Isibonelo2016-05-19 20:30:01.900Total82016-05-19 20:30:01.9001
800Isibonelo2016-05-19 20:30:01.900Up To Date82016-05-19 20:30:01.900NULL
801New Denmark2016-05-19 20:30:01.670Drop Link02016-05-19 20:30:01.670NULL
802New Denmark2016-05-19 20:30:01.670Offline12016-05-19 20:30:01.670NULL
803New Denmark2016-05-19 20:30:01.670Total42016-05-19 20:30:01.6701
804New Denmark2016-05-19 20:30:01.670Up To Date32016-05-19 20:30:01.670NULL
805New Vaal2016-05-19 20:30:00.597Drop Link12016-05-19 20:30:00.597NULL
806New Vaal2016-05-19 20:30:00.597Offline22016-05-19 20:30:00.597NULL
807New Vaal2016-05-19 20:30:00.597Total152016-05-19 20:30:00.5971
808New Vaal2016-05-19 20:30:00.597Up To Date122016-05-19 20:30:00.597NULL
793mafube2016-05-19 20:00:09.847Drop Link02016-05-19 20:00:09.847NULL
794mafube2016-05-19 20:00:09.847Offline22016-05-19 20:00:09.847NULL
795mafube2016-05-19 20:00:09.847Total202016-05-19 20:00:09.8471
796mafube2016-05-19 20:00:09.847Up To Date182016-05-19 20:00:09.847NULL
778Goedehoop North2016-05-19 20:00:02.557Drop Link02016-05-19 20:00:02.557NULL
782Goedehoop North2016-05-19 20:00:02.557Total212016-05-19 20:00:02.5571
783Goedehoop North2016-05-19 20:00:02.557Up To Date152016-05-19 20:00:02.557NULL
780Goedehoop North2016-05-19 20:00:02.557Offline62016-05-19 20:00:02.557NULL
789zibulo2016-05-19 20:00:01.750Drop Link12016-05-19 20:00:01.750NULL
790zibulo2016-05-19 20:00:01.750Offline32016-05-19 20:00:01.750NULL
791zibulo2016-05-19 20:00:01.750Total232016-05-19 20:00:01.7501
792zibulo2016-05-19 20:00:01.750Up To Date192016-05-19 20:00:01.750NULL
784Greenside2016-05-19 20:00:01.303Up To Date132016-05-19 20:00:01.303NULL
779Greenside2016-05-19 20:00:01.303Offline62016-05-19 20:00:01.303NULL
781Greenside2016-05-19 20:00:01.303Total192016-05-19 20:00:01.3031
777Greenside2016-05-19 20:00:01.303Drop Link02016-05-19 20:00:01.303NULL
785Goedehoop South2016-05-19 20:00:00.873Drop Link02016-05-19 20:00:00.873NULL
786Goedehoop South2016-05-19 20:00:00.873Offline212016-05-19 20:00:00.873NULL
787Goedehoop South2016-05-19 20:00:00.873Total212016-05-19 20:00:00.8731
788Goedehoop South2016-05-19 20:00:00.873Up To Date02016-05-19 20:00:00.873NULL
769RLT2016-05-12 21:00:01.353Drop Link02016-05-12 21:00:01.353NULL
770RLT2016-05-12 21:00:01.353Offline02016-05-12 21:00:01.353NULL
771RLT2016-05-12 21:00:01.353Total12016-05-12 21:00:01.3531
772RLT2016-05-12 21:00:01.353Up To Date12016-05-12 21:00:01.353NULL
761kriel2016-05-12 21:00:01.230Drop Link02016-05-12 21:00:01.230NULL
762kriel2016-05-12 21:00:01.230Offline02016-05-12 21:00:01.230NULL
763kriel2016-05-12 21:00:01.230Total162016-05-12 21:00:01.2301
764kriel2016-05-12 21:00:01.230Up To Date162016-05-12 21:00:01.230NULL
773landau2016-05-12 21:00:01.160Drop Link02016-05-12 21:00:01.160NULL
774landau2016-05-12 21:00:01.160Offline02016-05-12 21:00:01.160NULL
775landau2016-05-12 21:00:01.160Total32016-05-12 21:00:01.1601
776landau2016-05-12 21:00:01.160Up To Date32016-05-12 21:00:01.160NULL
765Klein kopje2016-05-12 21:00:00.530Drop Link02016-05-12 21:00:00.530NULL
766Klein kopje2016-05-12 21:00:00.530Offline02016-05-12 21:00:00.530NULL
767Klein kopje2016-05-12 21:00:00.530Total132016-05-12 21:00:00.5301
768Klein kopje2016-05-12 21:00:00.530Up To Date132016-05-12 21:00:00.530NULL
753New Vaal2016-05-12 20:30:01.183Drop LinkNULL2016-05-12 20:30:01.183NULL
754New Vaal2016-05-12 20:30:01.183OfflineNULL2016-05-12 20:30:01.183NULL
755New Vaal2016-05-12 20:30:01.183Total02016-05-12 20:30:01.1831
756New Vaal2016-05-12 20:30:01.183Up To DateNULL2016-05-12 20:30:01.183NULL
749Isibonelo2016-05-12 20:30:00.617Drop Link02016-05-12 20:30:00.617NULL
750Isibonelo2016-05-12 20:30:00.617Offline02016-05-12 20:30:00.617NULL
751Isibonelo2016-05-12 20:30:00.617Total82016-05-12 20:30:00.6171
752Isibonelo2016-05-12 20:30:00.617Up To Date82016-05-12 20:30:00.617NULL
757New Denmark2016-05-12 20:30:00.463Drop Link02016-05-12 20:30:00.463NULL
758New Denmark2016-05-12 20:30:00.463Offline02016-05-12 20:30:00.463NULL
759New Denmark2016-05-12 20:30:00.463Total42016-05-12 20:30:00.4631
760New Denmark2016-05-12 20:30:00.463Up To Date42016-05-12 20:30:00.463NULL
741mafube2016-05-12 20:00:05.267Drop LinkNULL2016-05-12 20:00:05.267NULL
742mafube2016-05-12 20:00:05.267OfflineNULL2016-05-12 20:00:05.267NULL
743mafube2016-05-12 20:00:05.267Total02016-05-12 20:00:05.2671
744mafube2016-05-12 20:00:05.267Up To DateNULL2016-05-12 20:00:05.267NULL
729Greenside2016-05-12 20:00:02.877Drop Link12016-05-12 20:00:02.877NULL
730Greenside2016-05-12 20:00:02.877Offline02016-05-12 20:00:02.877NULL
731Greenside2016-05-12 20:00:02.877Total122016-05-12 20:00:02.8771
732Greenside2016-05-12 20:00:02.877Up To Date112016-05-12 20:00:02.877NULL
745Goedehoop South2016-05-12 20:00:02.017Drop Link02016-05-12 20:00:02.017NULL
746Goedehoop South2016-05-12 20:00:02.017Offline212016-05-12 20:00:02.017NULL
747Goedehoop South2016-05-12 20:00:02.017Total212016-05-12 20:00:02.0171
748Goedehoop South2016-05-12 20:00:02.017Up To Date02016-05-12 20:00:02.017NULL
733Goedehoop North2016-05-12 20:00:01.713Drop Link12016-05-12 20:00:01.713NULL
734Goedehoop North2016-05-12 20:00:01.713Offline52016-05-12 20:00:01.713NULL
735Goedehoop North2016-05-12 20:00:01.713Total212016-05-12 20:00:01.7131
736Goedehoop North2016-05-12 20:00:01.713Up To Date152016-05-12 20:00:01.713NULL
737zibulo2016-05-12 20:00:01.290Drop Link32016-05-12 20:00:01.290NULL
738zibulo2016-05-12 20:00:01.290Offline12016-05-12 20:00:01.290NULL
739zibulo2016-05-12 20:00:01.290Total232016-05-12 20:00:01.2901
740zibulo2016-05-12 20:00:01.290Up To Date192016-05-12 20:00:01.290NULL
713Klein kopje2016-05-08 21:00:00.910Drop Link02016-05-08 21:00:00.910NULL
714Klein kopje2016-05-08 21:00:00.910Offline12016-05-08 21:00:00.910NULL
715Klein kopje2016-05-08 21:00:00.910Total32016-05-08 21:00:00.9101
716Klein kopje2016-05-08 21:00:00.910Up To Date22016-05-08 21:00:00.910NULL
721RLT2016-05-08 21:00:00.830Drop Link12016-05-08 21:00:00.830NULL
722RLT2016-05-08 21:00:00.830Offline02016-05-08 21:00:00.830NULL
723RLT2016-05-08 21:00:00.830Total82016-05-08 21:00:00.8301
724RLT2016-05-08 21:00:00.830Up To Date72016-05-08 21:00:00.830NULL
717kriel2016-05-08 21:00:00.667Drop Link12016-05-08 21:00:00.667NULL
718kriel2016-05-08 21:00:00.667Offline12016-05-08 21:00:00.667NULL
719kriel2016-05-08 21:00:00.667Total262016-05-08 21:00:00.6671
720kriel2016-05-08 21:00:00.667Up To Date242016-05-08 21:00:00.667NULL
725landau2016-05-08 21:00:00.383Drop Link02016-05-08 21:00:00.383NULL
726landau2016-05-08 21:00:00.383Offline02016-05-08 21:00:00.383NULL
727landau2016-05-08 21:00:00.383Total32016-05-08 21:00:00.3831
728landau2016-05-08 21:00:00.383Up To Date32016-05-08 21:00:00.383NULL
705New Denmark2016-05-08 20:30:01.197Drop Link02016-05-08 20:30:01.197NULL
706New Denmark2016-05-08 20:30:01.197Offline12016-05-08 20:30:01.197NULL
707New Denmark2016-05-08 20:30:01.197Total42016-05-08 20:30:01.1971
708New Denmark2016-05-08 20:30:01.197Up To Date32016-05-08 20:30:01.197NULL
693Isibonelo2016-05-08 20:30:00.877Drop Link02016-05-08 20:30:00.877NULL
694Isibonelo2016-05-08 20:30:00.877Offline02016-05-08 20:30:00.877NULL
695Isibonelo2016-05-08 20:30:00.877Total82016-05-08 20:30:00.8771
696Isibonelo2016-05-08 20:30:00.877Up To Date82016-05-08 20:30:00.877NULL
709New Vaal2016-05-08 20:30:00.553Drop LinkNULL2016-05-08 20:30:00.553NULL
710New Vaal2016-05-08 20:30:00.553OfflineNULL2016-05-08 20:30:00.553NULL
711New Vaal2016-05-08 20:30:00.553Total02016-05-08 20:30:00.5531
712New Vaal2016-05-08 20:30:00.553Up To DateNULL2016-05-08 20:30:00.553NULL
681Greenside2016-05-08 20:00:03.857Drop Link12016-05-08 20:00:03.857NULL
682Greenside2016-05-08 20:00:03.857Offline02016-05-08 20:00:03.857NULL
683Greenside2016-05-08 20:00:03.857Total122016-05-08 20:00:03.8571
684Greenside2016-05-08 20:00:03.857Up To Date112016-05-08 20:00:03.857NULL
697zibulo2016-05-08 20:00:03.430Drop Link12016-05-08 20:00:03.430NULL
698zibulo2016-05-08 20:00:03.430Offline12016-05-08 20:00:03.430NULL
699zibulo2016-05-08 20:00:03.430Total222016-05-08 20:00:03.4301
700zibulo2016-05-08 20:00:03.430Up To Date202016-05-08 20:00:03.430NULL
701Goedehoop South2016-05-08 20:00:02.900Drop Link02016-05-08 20:00:02.900NULL
702Goedehoop South2016-05-08 20:00:02.900Offline212016-05-08 20:00:02.900NULL
703Goedehoop South2016-05-08 20:00:02.900Total212016-05-08 20:00:02.9001
704Goedehoop South2016-05-08 20:00:02.900Up To Date02016-05-08 20:00:02.900NULL
689mafube2016-05-08 20:00:02.530Drop LinkNULL2016-05-08 20:00:02.530NULL
690mafube2016-05-08 20:00:02.530OfflineNULL2016-05-08 20:00:02.530NULL
691mafube2016-05-08 20:00:02.530Total02016-05-08 20:00:02.5301
692mafube2016-05-08 20:00:02.530Up To DateNULL2016-05-08 20:00:02.530NULL
685Goedehoop North2016-05-08 20:00:01.013Drop Link12016-05-08 20:00:01.013NULL
686Goedehoop North2016-05-08 20:00:01.013Offline62016-05-08 20:00:01.013NULL
687Goedehoop North2016-05-08 20:00:01.013Total212016-05-08 20:00:01.0131
688Goedehoop North2016-05-08 20:00:01.013Up To Date142016-05-08 20:00:01.013NULL
665RLT2016-05-07 21:00:01.387Drop Link12016-05-07 21:00:01.387NULL
666RLT2016-05-07 21:00:01.387Offline02016-05-07 21:00:01.387NULL
667RLT2016-05-07 21:00:01.387Total82016-05-07 21:00:01.3871
668RLT2016-05-07 21:00:01.387Up To Date72016-05-07 21:00:01.387NULL
673kriel2016-05-07 21:00:01.183Drop Link02016-05-07 21:00:01.183NULL
674kriel2016-05-07 21:00:01.183Offline02016-05-07 21:00:01.183NULL
675kriel2016-05-07 21:00:01.183Total162016-05-07 21:00:01.1831
676kriel2016-05-07 21:00:01.183Up To Date162016-05-07 21:00:01.183NULL
677landau2016-05-07 21:00:01.037Drop Link02016-05-07 21:00:01.037NULL
678landau2016-05-07 21:00:01.037Offline02016-05-07 21:00:01.037NULL
679landau2016-05-07 21:00:01.037Total32016-05-07 21:00:01.0371
680landau2016-05-07 21:00:01.037Up To Date32016-05-07 21:00:01.037NULL
669Klein kopje2016-05-07 21:00:00.650Drop Link02016-05-07 21:00:00.650NULL
670Klein kopje2016-05-07 21:00:00.650Offline02016-05-07 21:00:00.650NULL
671Klein kopje2016-05-07 21:00:00.650Total132016-05-07 21:00:00.6501
672Klein kopje2016-05-07 21:00:00.650Up To Date132016-05-07 21:00:00.650NULL
649Isibonelo2016-05-07 20:30:01.313Drop Link02016-05-07 20:30:01.313NULL
650Isibonelo2016-05-07 20:30:01.313Offline02016-05-07 20:30:01.313NULL
651Isibonelo2016-05-07 20:30:01.313Total82016-05-07 20:30:01.3131
652Isibonelo2016-05-07 20:30:01.313Up To Date82016-05-07 20:30:01.313NULL
657New Denmark2016-05-07 20:30:01.097Drop Link02016-05-07 20:30:01.097NULL
658New Denmark2016-05-07 20:30:01.097Offline152016-05-07 20:30:01.097NULL
659New Denmark2016-05-07 20:30:01.097Total482016-05-07 20:30:01.0971
662New Denmark2016-05-07 20:30:01.097Up To Date332016-05-07 20:30:01.097NULL
663New Vaal2016-05-07 20:30:00.520Total02016-05-07 20:30:00.5201
664New Vaal2016-05-07 20:30:00.520Up To DateNULL2016-05-07 20:30:00.520NULL
660New Vaal2016-05-07 20:30:00.520Drop LinkNULL2016-05-07 20:30:00.520NULL
661New Vaal2016-05-07 20:30:00.520OfflineNULL2016-05-07 20:30:00.520NULL
633Greenside2016-05-07 20:00:03.170Drop Link12016-05-07 20:00:03.170NULL
634Greenside2016-05-07 20:00:03.170Offline02016-05-07 20:00:03.170NULL
635Greenside2016-05-07 20:00:03.170Total122016-05-07 20:00:03.1701
636Greenside2016-05-07 20:00:03.170Up To Date112016-05-07 20:00:03.170NULL
641zibulo2016-05-07 20:00:02.860Drop Link12016-05-07 20:00:02.860NULL
642zibulo2016-05-07 20:00:02.860Offline12016-05-07 20:00:02.860NULL
643zibulo2016-05-07 20:00:02.860Total222016-05-07 20:00:02.8601
644zibulo2016-05-07 20:00:02.860Up To Date202016-05-07 20:00:02.860NULL
645mafube2016-05-07 20:00:02.753Drop Link02016-05-07 20:00:02.753NULL
646mafube2016-05-07 20:00:02.753Offline12016-05-07 20:00:02.753NULL
647mafube2016-05-07 20:00:02.753Total202016-05-07 20:00:02.7531
648mafube2016-05-07 20:00:02.753Up To Date192016-05-07 20:00:02.753NULL
653Goedehoop South2016-05-07 20:00:02.287Drop Link02016-05-07 20:00:02.287NULL
654Goedehoop South2016-05-07 20:00:02.287Offline212016-05-07 20:00:02.287NULL
655Goedehoop South2016-05-07 20:00:02.287Total212016-05-07 20:00:02.2871
656Goedehoop South2016-05-07 20:00:02.287Up To Date02016-05-07 20:00:02.287NULL
637Goedehoop North2016-05-07 20:00:01.097Drop Link12016-05-07 20:00:01.097NULL
638Goedehoop North2016-05-07 20:00:01.097Offline62016-05-07 20:00:01.097NULL
639Goedehoop North2016-05-07 20:00:01.097Total212016-05-07 20:00:01.0971
640Goedehoop North2016-05-07 20:00:01.097Up To Date142016-05-07 20:00:01.097NULL
625kriel2016-05-06 21:00:01.980Drop Link12016-05-06 21:00:01.980NULL
626kriel2016-05-06 21:00:01.980Offline02016-05-06 21:00:01.980NULL
627kriel2016-05-06 21:00:01.980Total162016-05-06 21:00:01.9801
628kriel2016-05-06 21:00:01.980Up To Date152016-05-06 21:00:01.980NULL
629landau2016-05-06 21:00:01.850Drop Link02016-05-06 21:00:01.850NULL
630landau2016-05-06 21:00:01.850Offline02016-05-06 21:00:01.850NULL
631landau2016-05-06 21:00:01.850Total32016-05-06 21:00:01.8501
632landau2016-05-06 21:00:01.850Up To Date32016-05-06 21:00:01.850NULL
617Klein kopje2016-05-06 21:00:00.757Drop Link02016-05-06 21:00:00.757NULL
618Klein kopje2016-05-06 21:00:00.757Offline12016-05-06 21:00:00.757NULL
619Klein kopje2016-05-06 21:00:00.757Total32016-05-06 21:00:00.7571
620Klein kopje2016-05-06 21:00:00.757Up To Date22016-05-06 21:00:00.757NULL
621RLT2016-05-06 21:00:00.370Drop Link12016-05-06 21:00:00.370NULL
622RLT2016-05-06 21:00:00.370Offline02016-05-06 21:00:00.370NULL
623RLT2016-05-06 21:00:00.370Total82016-05-06 21:00:00.3701
624RLT2016-05-06 21:00:00.370Up To Date72016-05-06 21:00:00.370NULL
597Isibonelo2016-05-06 20:30:01.190Drop Link02016-05-06 20:30:01.190NULL
599Isibonelo2016-05-06 20:30:01.190Offline02016-05-06 20:30:01.190NULL
600Isibonelo2016-05-06 20:30:01.190Total82016-05-06 20:30:01.1901
604Isibonelo2016-05-06 20:30:01.190Up To Date82016-05-06 20:30:01.190NULL
613New Vaal2016-05-06 20:30:01.117Drop LinkNULL2016-05-06 20:30:01.117NULL
614New Vaal2016-05-06 20:30:01.117OfflineNULL2016-05-06 20:30:01.117NULL
615New Vaal2016-05-06 20:30:01.117Total02016-05-06 20:30:01.1171
616New Vaal2016-05-06 20:30:01.117Up To DateNULL2016-05-06 20:30:01.117NULL
609New Denmark2016-05-06 20:30:01.113Drop Link02016-05-06 20:30:01.113NULL
610New Denmark2016-05-06 20:30:01.113Offline12016-05-06 20:30:01.113NULL
611New Denmark2016-05-06 20:30:01.113Total42016-05-06 20:30:01.1131
612New Denmark2016-05-06 20:30:01.113Up To Date32016-05-06 20:30:01.113NULL
601mafube2016-05-06 20:00:11.723OfflineNULL2016-05-06 20:00:11.723NULL
602mafube2016-05-06 20:00:11.723Total02016-05-06 20:00:11.7231
603mafube2016-05-06 20:00:11.723Up To DateNULL2016-05-06 20:00:11.723NULL
598mafube2016-05-06 20:00:11.723Drop LinkNULL2016-05-06 20:00:11.723NULL
585Greenside2016-05-06 20:00:02.207Drop Link12016-05-06 20:00:02.207NULL
586Greenside2016-05-06 20:00:02.207Offline02016-05-06 20:00:02.207NULL
587Greenside2016-05-06 20:00:02.207Total122016-05-06 20:00:02.2071
588Greenside2016-05-06 20:00:02.207Up To Date112016-05-06 20:00:02.207NULL
589Goedehoop North2016-05-06 20:00:01.637Drop Link12016-05-06 20:00:01.637NULL
590Goedehoop North2016-05-06 20:00:01.637Offline62016-05-06 20:00:01.637NULL
591Goedehoop North2016-05-06 20:00:01.637Total212016-05-06 20:00:01.6371
592Goedehoop North2016-05-06 20:00:01.637Up To Date142016-05-06 20:00:01.637NULL
593zibulo2016-05-06 20:00:01.183Drop Link02016-05-06 20:00:01.183NULL
594zibulo2016-05-06 20:00:01.183Offline02016-05-06 20:00:01.183NULL
595zibulo2016-05-06 20:00:01.183Total62016-05-06 20:00:01.1831
596zibulo2016-05-06 20:00:01.183Up To Date62016-05-06 20:00:01.183NULL
605Goedehoop South2016-05-06 20:00:01.040Drop Link02016-05-06 20:00:01.040NULL
606Goedehoop South2016-05-06 20:00:01.040Offline212016-05-06 20:00:01.040NULL
607Goedehoop South2016-05-06 20:00:01.040Total212016-05-06 20:00:01.0401
608Goedehoop South2016-05-06 20:00:01.040Up To Date02016-05-06 20:00:01.040NULL
581landau2016-05-05 21:00:02.253Drop Link02016-05-05 21:00:02.253NULL
582landau2016-05-05 21:00:02.253Offline02016-05-05 21:00:02.253NULL
583landau2016-05-05 21:00:02.253Total32016-05-05 21:00:02.2531
584landau2016-05-05 21:00:02.253Up To Date32016-05-05 21:00:02.253NULL
573RLT2016-05-05 21:00:00.973Drop Link12016-05-05 21:00:00.973NULL
574RLT2016-05-05 21:00:00.973Offline02016-05-05 21:00:00.973NULL
575RLT2016-05-05 21:00:00.973Total82016-05-05 21:00:00.9731
576RLT2016-05-05 21:00:00.973Up To Date72016-05-05 21:00:00.973NULL
569kriel2016-05-05 21:00:00.970Drop Link12016-05-05 21:00:00.970NULL
570kriel2016-05-05 21:00:00.970Offline02016-05-05 21:00:00.970NULL
571kriel2016-05-05 21:00:00.970Total162016-05-05 21:00:00.9701
572kriel2016-05-05 21:00:00.970Up To Date152016-05-05 21:00:00.970NULL
577Klein kopje2016-05-05 21:00:00.520Drop Link02016-05-05 21:00:00.520NULL
578Klein kopje2016-05-05 21:00:00.520Offline02016-05-05 21:00:00.520NULL
579Klein kopje2016-05-05 21:00:00.520Total132016-05-05 21:00:00.5201
580Klein kopje2016-05-05 21:00:00.520Up To Date132016-05-05 21:00:00.520NULL
549Isibonelo2016-05-05 20:30:00.610Drop Link02016-05-05 20:30:00.610NULL
550Isibonelo2016-05-05 20:30:00.610Offline02016-05-05 20:30:00.610NULL
551Isibonelo2016-05-05 20:30:00.610Total82016-05-05 20:30:00.6101
552Isibonelo2016-05-05 20:30:00.610Up To Date82016-05-05 20:30:00.610NULL
561New Vaal2016-05-05 20:30:00.550Drop LinkNULL2016-05-05 20:30:00.550NULL
562New Vaal2016-05-05 20:30:00.550OfflineNULL2016-05-05 20:30:00.550NULL
563New Vaal2016-05-05 20:30:00.550Total02016-05-05 20:30:00.5501
564New Vaal2016-05-05 20:30:00.550Up To DateNULL2016-05-05 20:30:00.550NULL
565New Denmark2016-05-05 20:30:00.450Drop Link02016-05-05 20:30:00.450NULL
566New Denmark2016-05-05 20:30:00.450Offline12016-05-05 20:30:00.450NULL
567New Denmark2016-05-05 20:30:00.450Total42016-05-05 20:30:00.4501
568New Denmark2016-05-05 20:30:00.450Up To Date32016-05-05 20:30:00.450NULL
557Greenside2016-05-05 20:00:22.267Drop Link12016-05-05 20:00:22.267NULL
558Greenside2016-05-05 20:00:22.267Offline02016-05-05 20:00:22.267NULL
559Greenside2016-05-05 20:00:22.267Total122016-05-05 20:00:22.2671
560Greenside2016-05-05 20:00:22.267Up To Date112016-05-05 20:00:22.267NULL
545mafube2016-05-05 20:00:04.823Drop Link02016-05-05 20:00:04.823NULL
546mafube2016-05-05 20:00:04.823Offline12016-05-05 20:00:04.823NULL
547mafube2016-05-05 20:00:04.823Total202016-05-05 20:00:04.8231
548mafube2016-05-05 20:00:04.823Up To Date192016-05-05 20:00:04.823NULL
553Goedehoop South2016-05-05 20:00:04.653Drop Link02016-05-05 20:00:04.653NULL
554Goedehoop South2016-05-05 20:00:04.653Offline212016-05-05 20:00:04.653NULL
555Goedehoop South2016-05-05 20:00:04.653Total212016-05-05 20:00:04.6531
556Goedehoop South2016-05-05 20:00:04.653Up To Date02016-05-05 20:00:04.653NULL
541Goedehoop North2016-05-05 20:00:01.403Drop Link12016-05-05 20:00:01.403NULL
542Goedehoop North2016-05-05 20:00:01.403Offline62016-05-05 20:00:01.403NULL
543Goedehoop North2016-05-05 20:00:01.403Total212016-05-05 20:00:01.4031
544Goedehoop North2016-05-05 20:00:01.403Up To Date142016-05-05 20:00:01.403NULL
537zibulo2016-05-05 20:00:01.193Drop Link12016-05-05 20:00:01.193NULL
538zibulo2016-05-05 20:00:01.193Offline12016-05-05 20:00:01.193NULL
539zibulo2016-05-05 20:00:01.193Total222016-05-05 20:00:01.1931
540zibulo2016-05-05 20:00:01.193Up To Date202016-05-05 20:00:01.193NULL
521RLT2016-05-04 21:00:01.677Drop Link12016-05-04 21:00:01.677NULL
522RLT2016-05-04 21:00:01.677Offline02016-05-04 21:00:01.677NULL
523RLT2016-05-04 21:00:01.677Total82016-05-04 21:00:01.6771
524RLT2016-05-04 21:00:01.677Up To Date72016-05-04 21:00:01.677NULL
533landau2016-05-04 21:00:01.403Drop Link02016-05-04 21:00:01.403NULL
534landau2016-05-04 21:00:01.403Offline02016-05-04 21:00:01.403NULL
535landau2016-05-04 21:00:01.403Total32016-05-04 21:00:01.4031
536landau2016-05-04 21:00:01.403Up To Date32016-05-04 21:00:01.403NULL
525kriel2016-05-04 21:00:00.857Drop Link02016-05-04 21:00:00.857NULL
526kriel2016-05-04 21:00:00.857Offline02016-05-04 21:00:00.857NULL
527kriel2016-05-04 21:00:00.857Total162016-05-04 21:00:00.8571
528kriel2016-05-04 21:00:00.857Up To Date162016-05-04 21:00:00.857NULL
529Klein kopje2016-05-04 21:00:00.763Drop Link02016-05-04 21:00:00.763NULL
530Klein kopje2016-05-04 21:00:00.763Offline12016-05-04 21:00:00.763NULL
531Klein kopje2016-05-04 21:00:00.763Total32016-05-04 21:00:00.7631
532Klein kopje2016-05-04 21:00:00.763Up To Date22016-05-04 21:00:00.763NULL
505Isibonelo2016-05-04 20:30:01.003Drop Link02016-05-04 20:30:01.003NULL
506Isibonelo2016-05-04 20:30:01.003Offline02016-05-04 20:30:01.003NULL
507Isibonelo2016-05-04 20:30:01.003Total92016-05-04 20:30:01.0031
508Isibonelo2016-05-04 20:30:01.003Up To Date92016-05-04 20:30:01.003NULL
517New Denmark2016-05-04 20:30:00.977Drop Link02016-05-04 20:30:00.977NULL
518New Denmark2016-05-04 20:30:00.977Offline152016-05-04 20:30:00.977NULL
519New Denmark2016-05-04 20:30:00.977Total482016-05-04 20:30:00.9771
520New Denmark2016-05-04 20:30:00.977Up To Date332016-05-04 20:30:00.977NULL
513New Vaal2016-05-04 20:30:00.457Drop LinkNULL2016-05-04 20:30:00.457NULL
514New Vaal2016-05-04 20:30:00.457OfflineNULL2016-05-04 20:30:00.457NULL
515New Vaal2016-05-04 20:30:00.457Total02016-05-04 20:30:00.4571
516New Vaal2016-05-04 20:30:00.457Up To DateNULL2016-05-04 20:30:00.457NULL
489Greenside2016-05-04 20:00:06.343Drop Link12016-05-04 20:00:06.343NULL
490Greenside2016-05-04 20:00:06.343Offline02016-05-04 20:00:06.343NULL
491Greenside2016-05-04 20:00:06.343Total122016-05-04 20:00:06.3431
492Greenside2016-05-04 20:00:06.343Up To Date112016-05-04 20:00:06.343NULL
501mafube2016-05-04 20:00:03.630Total202016-05-04 20:00:03.6301
497mafube2016-05-04 20:00:03.630Drop Link02016-05-04 20:00:03.630NULL
498mafube2016-05-04 20:00:03.630Offline12016-05-04 20:00:03.630NULL
504mafube2016-05-04 20:00:03.630Up To Date192016-05-04 20:00:03.630NULL
499Goedehoop North2016-05-04 20:00:01.680Drop Link12016-05-04 20:00:01.680NULL
500Goedehoop North2016-05-04 20:00:01.680Offline62016-05-04 20:00:01.680NULL
502Goedehoop North2016-05-04 20:00:01.680Total212016-05-04 20:00:01.6801
503Goedehoop North2016-05-04 20:00:01.680Up To Date142016-05-04 20:00:01.680NULL
509Goedehoop South2016-05-04 20:00:01.327Drop Link02016-05-04 20:00:01.327NULL
510Goedehoop South2016-05-04 20:00:01.327Offline212016-05-04 20:00:01.327NULL
511Goedehoop South2016-05-04 20:00:01.327Total212016-05-04 20:00:01.3271
512Goedehoop South2016-05-04 20:00:01.327Up To Date02016-05-04 20:00:01.327NULL
493zibulo2016-05-04 20:00:01.030Drop Link12016-05-04 20:00:01.030NULL
494zibulo2016-05-04 20:00:01.030Offline12016-05-04 20:00:01.030NULL
495zibulo2016-05-04 20:00:01.030Total222016-05-04 20:00:01.0301
496zibulo2016-05-04 20:00:01.030Up To Date202016-05-04 20:00:01.030NULL
473kriel2016-05-03 21:00:02.200Drop Link02016-05-03 21:00:02.200NULL
474kriel2016-05-03 21:00:02.200Offline02016-05-03 21:00:02.200NULL
475kriel2016-05-03 21:00:02.200Total162016-05-03 21:00:02.2001
476kriel2016-05-03 21:00:02.200Up To Date162016-05-03 21:00:02.200NULL
485landau2016-05-03 21:00:01.177Drop Link02016-05-03 21:00:01.177NULL
486landau2016-05-03 21:00:01.177Offline02016-05-03 21:00:01.177NULL
487landau2016-05-03 21:00:01.177Total32016-05-03 21:00:01.1771
488landau2016-05-03 21:00:01.177Up To Date32016-05-03 21:00:01.177NULL
481Klein kopje2016-05-03 21:00:01.147Drop Link02016-05-03 21:00:01.147NULL
482Klein kopje2016-05-03 21:00:01.147Offline12016-05-03 21:00:01.147NULL
483Klein kopje2016-05-03 21:00:01.147Total32016-05-03 21:00:01.1471
484Klein kopje2016-05-03 21:00:01.147Up To Date22016-05-03 21:00:01.147NULL
477RLT2016-05-03 21:00:00.760Drop Link12016-05-03 21:00:00.760NULL
478RLT2016-05-03 21:00:00.760Offline02016-05-03 21:00:00.760NULL
479RLT2016-05-03 21:00:00.760Total82016-05-03 21:00:00.7601
480RLT2016-05-03 21:00:00.760Up To Date72016-05-03 21:00:00.760NULL
462Isibonelo2016-05-03 20:30:01.380Offline02016-05-03 20:30:01.380NULL
463Isibonelo2016-05-03 20:30:01.380Total82016-05-03 20:30:01.3801
464Isibonelo2016-05-03 20:30:01.380Up To Date82016-05-03 20:30:01.380NULL
458Isibonelo2016-05-03 20:30:01.380Drop Link02016-05-03 20:30:01.380NULL
465New Denmark2016-05-03 20:30:01.047Drop Link02016-05-03 20:30:01.047NULL
466New Denmark2016-05-03 20:30:01.047Offline152016-05-03 20:30:01.047NULL
467New Denmark2016-05-03 20:30:01.047Total482016-05-03 20:30:01.0471
468New Denmark2016-05-03 20:30:01.047Up To Date332016-05-03 20:30:01.047NULL
469New Vaal2016-05-03 20:30:00.797Drop Link22016-05-03 20:30:00.797NULL
470New Vaal2016-05-03 20:30:00.797Offline22016-05-03 20:30:00.797NULL
471New Vaal2016-05-03 20:30:00.797Total152016-05-03 20:30:00.7971
472New Vaal2016-05-03 20:30:00.797Up To Date112016-05-03 20:30:00.797NULL
453Greenside2016-05-03 20:00:02.807Drop Link12016-05-03 20:00:02.807NULL
454Greenside2016-05-03 20:00:02.807Offline02016-05-03 20:00:02.807NULL
455Greenside2016-05-03 20:00:02.807Total122016-05-03 20:00:02.8071
456Greenside2016-05-03 20:00:02.807Up To Date112016-05-03 20:00:02.807NULL
449mafube2016-05-03 20:00:02.670Drop Link02016-05-03 20:00:02.670NULL
450mafube2016-05-03 20:00:02.670Offline12016-05-03 20:00:02.670NULL
451mafube2016-05-03 20:00:02.670Total202016-05-03 20:00:02.6701
452mafube2016-05-03 20:00:02.670Up To Date192016-05-03 20:00:02.670NULL
457Goedehoop South2016-05-03 20:00:01.790Drop Link02016-05-03 20:00:01.790NULL
459Goedehoop South2016-05-03 20:00:01.790Offline212016-05-03 20:00:01.790NULL
460Goedehoop South2016-05-03 20:00:01.790Total212016-05-03 20:00:01.7901
461Goedehoop South2016-05-03 20:00:01.790Up To Date02016-05-03 20:00:01.790NULL
441zibulo2016-05-03 20:00:01.613Drop Link02016-05-03 20:00:01.613NULL
442zibulo2016-05-03 20:00:01.613Offline02016-05-03 20:00:01.613NULL
443zibulo2016-05-03 20:00:01.613Total62016-05-03 20:00:01.6131
444zibulo2016-05-03 20:00:01.613Up To Date62016-05-03 20:00:01.613NULL
445Goedehoop North2016-05-03 20:00:01.007Drop Link12016-05-03 20:00:01.007NULL
446Goedehoop North2016-05-03 20:00:01.007Offline62016-05-03 20:00:01.007NULL
447Goedehoop North2016-05-03 20:00:01.007Total212016-05-03 20:00:01.0071
448Goedehoop North2016-05-03 20:00:01.007Up To Date142016-05-03 20:00:01.007NULL
429RLT2016-05-02 21:00:01.720Drop Link02016-05-02 21:00:01.720NULL
430RLT2016-05-02 21:00:01.720Offline02016-05-02 21:00:01.720NULL
434RLT2016-05-02 21:00:01.720Up To Date12016-05-02 21:00:01.720NULL
432RLT2016-05-02 21:00:01.720Total12016-05-02 21:00:01.7201
433Klein kopje2016-05-02 21:00:01.173Offline02016-05-02 21:00:01.173NULL
435Klein kopje2016-05-02 21:00:01.173Total132016-05-02 21:00:01.1731
436Klein kopje2016-05-02 21:00:01.173Up To Date132016-05-02 21:00:01.173NULL
431Klein kopje2016-05-02 21:00:01.173Drop Link02016-05-02 21:00:01.173NULL
425kriel2016-05-02 21:00:01.147Drop Link02016-05-02 21:00:01.147NULL
426kriel2016-05-02 21:00:01.147Offline02016-05-02 21:00:01.147NULL
427kriel2016-05-02 21:00:01.147Total162016-05-02 21:00:01.1471
428kriel2016-05-02 21:00:01.147Up To Date162016-05-02 21:00:01.147NULL
437landau2016-05-02 21:00:00.757Drop Link02016-05-02 21:00:00.757NULL
438landau2016-05-02 21:00:00.757Offline02016-05-02 21:00:00.757NULL
439landau2016-05-02 21:00:00.757Total32016-05-02 21:00:00.7571
440landau2016-05-02 21:00:00.757Up To Date32016-05-02 21:00:00.757NULL
417New Vaal2016-05-02 20:30:00.947Drop LinkNULL2016-05-02 20:30:00.947NULL
418New Vaal2016-05-02 20:30:00.947OfflineNULL2016-05-02 20:30:00.947NULL
419New Vaal2016-05-02 20:30:00.947Total02016-05-02 20:30:00.9471
420New Vaal2016-05-02 20:30:00.947Up To DateNULL2016-05-02 20:30:00.947NULL
421New Denmark2016-05-02 20:30:00.587Drop Link02016-05-02 20:30:00.587NULL
422New Denmark2016-05-02 20:30:00.587Offline12016-05-02 20:30:00.587NULL
423New Denmark2016-05-02 20:30:00.587Total42016-05-02 20:30:00.5871
424New Denmark2016-05-02 20:30:00.587Up To Date32016-05-02 20:30:00.587NULL
405Isibonelo2016-05-02 20:30:00.387Drop Link02016-05-02 20:30:00.387NULL
406Isibonelo2016-05-02 20:30:00.387Offline02016-05-02 20:30:00.387NULL
407Isibonelo2016-05-02 20:30:00.387Total92016-05-02 20:30:00.3871
408Isibonelo2016-05-02 20:30:00.387Up To Date92016-05-02 20:30:00.387NULL
397mafube2016-05-02 20:00:13.393Drop Link02016-05-02 20:00:13.393NULL
398mafube2016-05-02 20:00:13.393Offline12016-05-02 20:00:13.393NULL
399mafube2016-05-02 20:00:13.393Total202016-05-02 20:00:13.3931
400mafube2016-05-02 20:00:13.393Up To Date192016-05-02 20:00:13.393NULL
393Greenside2016-05-02 20:00:02.467Drop Link12016-05-02 20:00:02.467NULL
394Greenside2016-05-02 20:00:02.467Offline02016-05-02 20:00:02.467NULL
395Greenside2016-05-02 20:00:02.467Total122016-05-02 20:00:02.4671
396Greenside2016-05-02 20:00:02.467Up To Date112016-05-02 20:00:02.467NULL
409Goedehoop South2016-05-02 20:00:01.757Drop Link02016-05-02 20:00:01.757NULL
410Goedehoop South2016-05-02 20:00:01.757Offline212016-05-02 20:00:01.757NULL
411Goedehoop South2016-05-02 20:00:01.757Total212016-05-02 20:00:01.7571
412Goedehoop South2016-05-02 20:00:01.757Up To Date02016-05-02 20:00:01.757NULL
401Goedehoop North2016-05-02 20:00:01.690Drop Link12016-05-02 20:00:01.690NULL
402Goedehoop North2016-05-02 20:00:01.690Offline62016-05-02 20:00:01.690NULL
403Goedehoop North2016-05-02 20:00:01.690Total212016-05-02 20:00:01.6901
404Goedehoop North2016-05-02 20:00:01.690Up To Date142016-05-02 20:00:01.690NULL
413zibulo2016-05-02 20:00:01.613Drop Link12016-05-02 20:00:01.613NULL
414zibulo2016-05-02 20:00:01.613Offline12016-05-02 20:00:01.613NULL
415zibulo2016-05-02 20:00:01.613Total222016-05-02 20:00:01.6131
416zibulo2016-05-02 20:00:01.613Up To Date202016-05-02 20:00:01.613NULL
385RLT2016-05-01 21:00:01.540Drop Link02016-05-01 21:00:01.540NULL
386RLT2016-05-01 21:00:01.540Offline02016-05-01 21:00:01.540NULL
387RLT2016-05-01 21:00:01.540Total12016-05-01 21:00:01.5401
388RLT2016-05-01 21:00:01.540Up To Date12016-05-01 21:00:01.540NULL
377kriel2016-05-01 21:00:01.510Drop Link02016-05-01 21:00:01.510NULL
378kriel2016-05-01 21:00:01.510Offline02016-05-01 21:00:01.510NULL
379kriel2016-05-01 21:00:01.510Total162016-05-01 21:00:01.5101
380kriel2016-05-01 21:00:01.510Up To Date162016-05-01 21:00:01.510NULL
389landau2016-05-01 21:00:00.963Drop Link02016-05-01 21:00:00.963NULL
390landau2016-05-01 21:00:00.963Offline02016-05-01 21:00:00.963NULL
391landau2016-05-01 21:00:00.963Total32016-05-01 21:00:00.9631
392landau2016-05-01 21:00:00.963Up To Date32016-05-01 21:00:00.963NULL
381Klein kopje2016-05-01 21:00:00.820Drop Link02016-05-01 21:00:00.820NULL
382Klein kopje2016-05-01 21:00:00.820Offline132016-05-01 21:00:00.820NULL
383Klein kopje2016-05-01 21:00:00.820Total132016-05-01 21:00:00.8201
384Klein kopje2016-05-01 21:00:00.820Up To Date02016-05-01 21:00:00.820NULL
365Isibonelo2016-05-01 20:30:01.097Drop Link02016-05-01 20:30:01.097NULL
366Isibonelo2016-05-01 20:30:01.097Offline02016-05-01 20:30:01.097NULL
367Isibonelo2016-05-01 20:30:01.097Total82016-05-01 20:30:01.0971
368Isibonelo2016-05-01 20:30:01.097Up To Date82016-05-01 20:30:01.097NULL
369New Vaal2016-05-01 20:30:00.837Drop LinkNULL2016-05-01 20:30:00.837NULL
370New Vaal2016-05-01 20:30:00.837OfflineNULL2016-05-01 20:30:00.837NULL
371New Vaal2016-05-01 20:30:00.837Total02016-05-01 20:30:00.8371
372New Vaal2016-05-01 20:30:00.837Up To DateNULL2016-05-01 20:30:00.837NULL
373New Denmark2016-05-01 20:30:00.357Drop Link02016-05-01 20:30:00.357NULL
374New Denmark2016-05-01 20:30:00.357Offline12016-05-01 20:30:00.357NULL
375New Denmark2016-05-01 20:30:00.357Total42016-05-01 20:30:00.3571
376New Denmark2016-05-01 20:30:00.357Up To Date32016-05-01 20:30:00.357NULL
360mafube2016-05-01 20:00:06.350Drop Link02016-05-01 20:00:06.350NULL
362mafube2016-05-01 20:00:06.350Offline12016-05-01 20:00:06.350NULL
363mafube2016-05-01 20:00:06.350Total202016-05-01 20:00:06.3501
364mafube2016-05-01 20:00:06.350Up To Date192016-05-01 20:00:06.350NULL
345Greenside2016-05-01 20:00:02.837Drop Link12016-05-01 20:00:02.837NULL
346Greenside2016-05-01 20:00:02.837Offline02016-05-01 20:00:02.837NULL
347Greenside2016-05-01 20:00:02.837Total122016-05-01 20:00:02.8371
348Greenside2016-05-01 20:00:02.837Up To Date112016-05-01 20:00:02.837NULL
353Goedehoop South2016-05-01 20:00:02.187Drop Link02016-05-01 20:00:02.187NULL
354Goedehoop South2016-05-01 20:00:02.187Offline212016-05-01 20:00:02.187NULL
355Goedehoop South2016-05-01 20:00:02.187Total212016-05-01 20:00:02.1871
356Goedehoop South2016-05-01 20:00:02.187Up To Date02016-05-01 20:00:02.187NULL
357zibulo2016-05-01 20:00:01.897Drop Link02016-05-01 20:00:01.897NULL
358zibulo2016-05-01 20:00:01.897Offline02016-05-01 20:00:01.897NULL
359zibulo2016-05-01 20:00:01.897Total62016-05-01 20:00:01.8971
361zibulo2016-05-01 20:00:01.897Up To Date62016-05-01 20:00:01.897NULL
349Goedehoop North2016-05-01 20:00:01.453Drop Link12016-05-01 20:00:01.453NULL
350Goedehoop North2016-05-01 20:00:01.453Offline62016-05-01 20:00:01.453NULL
351Goedehoop North2016-05-01 20:00:01.453Total212016-05-01 20:00:01.4531
352Goedehoop North2016-05-01 20:00:01.453Up To Date142016-05-01 20:00:01.453NULL
333kriel2016-04-30 21:00:01.443Drop Link02016-04-30 21:00:01.443NULL
334kriel2016-04-30 21:00:01.443Offline02016-04-30 21:00:01.443NULL
335kriel2016-04-30 21:00:01.443Total162016-04-30 21:00:01.4431
336kriel2016-04-30 21:00:01.443Up To Date162016-04-30 21:00:01.443NULL
341landau2016-04-30 21:00:00.853Drop Link02016-04-30 21:00:00.853NULL
342landau2016-04-30 21:00:00.853Offline02016-04-30 21:00:00.853NULL
343landau2016-04-30 21:00:00.853Total32016-04-30 21:00:00.8531
344landau2016-04-30 21:00:00.853Up To Date32016-04-30 21:00:00.853NULL
337RLT2016-04-30 21:00:00.787Drop Link12016-04-30 21:00:00.787NULL
338RLT2016-04-30 21:00:00.787Offline02016-04-30 21:00:00.787NULL
339RLT2016-04-30 21:00:00.787Total82016-04-30 21:00:00.7871
340RLT2016-04-30 21:00:00.787Up To Date72016-04-30 21:00:00.787NULL
329Klein kopje2016-04-30 21:00:00.650Drop Link02016-04-30 21:00:00.650NULL
330Klein kopje2016-04-30 21:00:00.650Offline132016-04-30 21:00:00.650NULL
331Klein kopje2016-04-30 21:00:00.650Total132016-04-30 21:00:00.6501
332Klein kopje2016-04-30 21:00:00.650Up To Date02016-04-30 21:00:00.650NULL
305Isibonelo2016-04-30 20:30:01.380Drop Link02016-04-30 20:30:01.380NULL
306Isibonelo2016-04-30 20:30:01.380Offline02016-04-30 20:30:01.380NULL
307Isibonelo2016-04-30 20:30:01.380Total82016-04-30 20:30:01.3801
308Isibonelo2016-04-30 20:30:01.380Up To Date82016-04-30 20:30:01.380NULL
321New Denmark2016-04-30 20:30:00.860Drop Link02016-04-30 20:30:00.860NULL
324New Denmark2016-04-30 20:30:00.860Offline12016-04-30 20:30:00.860NULL
327New Denmark2016-04-30 20:30:00.860Total42016-04-30 20:30:00.8601
328New Denmark2016-04-30 20:30:00.860Up To Date32016-04-30 20:30:00.860NULL
325New Vaal2016-04-30 20:30:00.770Total02016-04-30 20:30:00.7701
326New Vaal2016-04-30 20:30:00.770Up To DateNULL2016-04-30 20:30:00.770NULL
322New Vaal2016-04-30 20:30:00.770Drop LinkNULL2016-04-30 20:30:00.770NULL
323New Vaal2016-04-30 20:30:00.770OfflineNULL2016-04-30 20:30:00.770NULL
313Goedehoop South2016-04-30 20:00:13.013Drop Link02016-04-30 20:00:13.013NULL
314Goedehoop South2016-04-30 20:00:13.013Offline212016-04-30 20:00:13.013NULL
315Goedehoop South2016-04-30 20:00:13.013Total212016-04-30 20:00:13.0131
316Goedehoop South2016-04-30 20:00:13.013Up To Date02016-04-30 20:00:13.013NULL
309zibulo2016-04-30 20:00:06.683Drop Link02016-04-30 20:00:06.683NULL
310zibulo2016-04-30 20:00:06.683Offline02016-04-30 20:00:06.683NULL
311zibulo2016-04-30 20:00:06.683Total62016-04-30 20:00:06.6831
312zibulo2016-04-30 20:00:06.683Up To Date62016-04-30 20:00:06.683NULL
301mafube2016-04-30 20:00:06.367Drop Link02016-04-30 20:00:06.367NULL
302mafube2016-04-30 20:00:06.367Offline12016-04-30 20:00:06.367NULL
303mafube2016-04-30 20:00:06.367Total202016-04-30 20:00:06.3671
304mafube2016-04-30 20:00:06.367Up To Date192016-04-30 20:00:06.367NULL
317Greenside2016-04-30 20:00:02.810Drop Link12016-04-30 20:00:02.810NULL
318Greenside2016-04-30 20:00:02.810Offline02016-04-30 20:00:02.810NULL
319Greenside2016-04-30 20:00:02.810Total122016-04-30 20:00:02.8101
320Greenside2016-04-30 20:00:02.810Up To Date112016-04-30 20:00:02.810NULL
297Goedehoop North2016-04-30 20:00:01.203Drop Link12016-04-30 20:00:01.203NULL
298Goedehoop North2016-04-30 20:00:01.203Offline62016-04-30 20:00:01.203NULL
299Goedehoop North2016-04-30 20:00:01.203Total212016-04-30 20:00:01.2031
300Goedehoop North2016-04-30 20:00:01.203Up To Date142016-04-30 20:00:01.203NULL
281kriel2016-04-29 21:00:01.740Drop Link02016-04-29 21:00:01.740NULL
282kriel2016-04-29 21:00:01.740Offline02016-04-29 21:00:01.740NULL
283kriel2016-04-29 21:00:01.740Total162016-04-29 21:00:01.7401
284kriel2016-04-29 21:00:01.740Up To Date162016-04-29 21:00:01.740NULL
289Klein kopje2016-04-29 21:00:01.287Drop Link02016-04-29 21:00:01.287NULL
290Klein kopje2016-04-29 21:00:01.287Offline12016-04-29 21:00:01.287NULL
291Klein kopje2016-04-29 21:00:01.287Total32016-04-29 21:00:01.2871
292Klein kopje2016-04-29 21:00:01.287Up To Date22016-04-29 21:00:01.287NULL
285RLT2016-04-29 21:00:00.880Drop Link02016-04-29 21:00:00.880NULL
286RLT2016-04-29 21:00:00.880Offline02016-04-29 21:00:00.880NULL
287RLT2016-04-29 21:00:00.880Total12016-04-29 21:00:00.8801
288RLT2016-04-29 21:00:00.880Up To Date12016-04-29 21:00:00.880NULL
293landau2016-04-29 21:00:00.877Drop Link02016-04-29 21:00:00.877NULL
294landau2016-04-29 21:00:00.877Offline02016-04-29 21:00:00.877NULL
295landau2016-04-29 21:00:00.877Total32016-04-29 21:00:00.8771
296landau2016-04-29 21:00:00.877Up To Date32016-04-29 21:00:00.877NULL
257Isibonelo2016-04-29 20:30:00.757Drop Link02016-04-29 20:30:00.757NULL
258Isibonelo2016-04-29 20:30:00.757Offline02016-04-29 20:30:00.757NULL
259Isibonelo2016-04-29 20:30:00.757Total82016-04-29 20:30:00.7571
260Isibonelo2016-04-29 20:30:00.757Up To Date82016-04-29 20:30:00.757NULL
273New Vaal2016-04-29 20:30:00.463Drop Link12016-04-29 20:30:00.463NULL
274New Vaal2016-04-29 20:30:00.463Offline32016-04-29 20:30:00.463NULL
275New Vaal2016-04-29 20:30:00.463Total152016-04-29 20:30:00.4631
276New Vaal2016-04-29 20:30:00.463Up To Date112016-04-29 20:30:00.463NULL
277New Denmark2016-04-29 20:30:00.440Drop Link02016-04-29 20:30:00.440NULL
278New Denmark2016-04-29 20:30:00.440Offline12016-04-29 20:30:00.440NULL
279New Denmark2016-04-29 20:30:00.440Total42016-04-29 20:30:00.4401
280New Denmark2016-04-29 20:30:00.440Up To Date32016-04-29 20:30:00.440NULL
269mafube2016-04-29 20:00:06.457Drop Link02016-04-29 20:00:06.457NULL
270mafube2016-04-29 20:00:06.457Offline12016-04-29 20:00:06.457NULL
271mafube2016-04-29 20:00:06.457Total202016-04-29 20:00:06.4571
272mafube2016-04-29 20:00:06.457Up To Date192016-04-29 20:00:06.457NULL
253Greenside2016-04-29 20:00:04.013Drop Link12016-04-29 20:00:04.013NULL
254Greenside2016-04-29 20:00:04.013Offline02016-04-29 20:00:04.013NULL
255Greenside2016-04-29 20:00:04.013Total122016-04-29 20:00:04.0131
256Greenside2016-04-29 20:00:04.013Up To Date112016-04-29 20:00:04.013NULL
261Goedehoop South2016-04-29 20:00:02.153Drop Link02016-04-29 20:00:02.153NULL
262Goedehoop South2016-04-29 20:00:02.153Offline212016-04-29 20:00:02.153NULL
263Goedehoop South2016-04-29 20:00:02.153Total212016-04-29 20:00:02.1531
264Goedehoop South2016-04-29 20:00:02.153Up To Date02016-04-29 20:00:02.153NULL
265zibulo2016-04-29 20:00:01.550Drop Link02016-04-29 20:00:01.550NULL
266zibulo2016-04-29 20:00:01.550Offline02016-04-29 20:00:01.550NULL
267zibulo2016-04-29 20:00:01.550Total62016-04-29 20:00:01.5501
268zibulo2016-04-29 20:00:01.550Up To Date62016-04-29 20:00:01.550NULL
249Goedehoop North2016-04-29 20:00:01.227Drop Link12016-04-29 20:00:01.227NULL
250Goedehoop North2016-04-29 20:00:01.227Offline62016-04-29 20:00:01.227NULL
251Goedehoop North2016-04-29 20:00:01.227Total212016-04-29 20:00:01.2271
252Goedehoop North2016-04-29 20:00:01.227Up To Date142016-04-29 20:00:01.227NULL
237Klein kopje2016-04-28 21:00:01.993Drop Link02016-04-28 21:00:01.993NULL
238Klein kopje2016-04-28 21:00:01.993Offline132016-04-28 21:00:01.993NULL
239Klein kopje2016-04-28 21:00:01.993Total132016-04-28 21:00:01.9931
240Klein kopje2016-04-28 21:00:01.993Up To Date02016-04-28 21:00:01.993NULL
245landau2016-04-28 21:00:01.470Drop Link02016-04-28 21:00:01.470NULL
246landau2016-04-28 21:00:01.470Offline02016-04-28 21:00:01.470NULL
247landau2016-04-28 21:00:01.470Total32016-04-28 21:00:01.4701
248landau2016-04-28 21:00:01.470Up To Date32016-04-28 21:00:01.470NULL
233kriel2016-04-28 21:00:00.847Drop Link02016-04-28 21:00:00.847NULL
234kriel2016-04-28 21:00:00.847Offline02016-04-28 21:00:00.847NULL
235kriel2016-04-28 21:00:00.847Total162016-04-28 21:00:00.8471
236kriel2016-04-28 21:00:00.847Up To Date162016-04-28 21:00:00.847NULL
241RLT2016-04-28 21:00:00.583Drop Link12016-04-28 21:00:00.583NULL
242RLT2016-04-28 21:00:00.583Offline02016-04-28 21:00:00.583NULL
243RLT2016-04-28 21:00:00.583Total82016-04-28 21:00:00.5831
244RLT2016-04-28 21:00:00.583Up To Date72016-04-28 21:00:00.583NULL
225New Denmark2016-04-28 20:30:01.007Drop Link02016-04-28 20:30:01.007NULL
226New Denmark2016-04-28 20:30:01.007Offline12016-04-28 20:30:01.007NULL
227New Denmark2016-04-28 20:30:01.007Total42016-04-28 20:30:01.0071
228New Denmark2016-04-28 20:30:01.007Up To Date32016-04-28 20:30:01.007NULL
229New Vaal2016-04-28 20:30:00.903Drop LinkNULL2016-04-28 20:30:00.903NULL
230New Vaal2016-04-28 20:30:00.903OfflineNULL2016-04-28 20:30:00.903NULL
231New Vaal2016-04-28 20:30:00.903Total02016-04-28 20:30:00.9031
232New Vaal2016-04-28 20:30:00.903Up To DateNULL2016-04-28 20:30:00.903NULL
213Isibonelo2016-04-28 20:30:00.767Drop Link02016-04-28 20:30:00.767NULL
214Isibonelo2016-04-28 20:30:00.767Offline02016-04-28 20:30:00.767NULL
215Isibonelo2016-04-28 20:30:00.767Total82016-04-28 20:30:00.7671
216Isibonelo2016-04-28 20:30:00.767Up To Date82016-04-28 20:30:00.767NULL
201Greenside2016-04-28 20:00:05.080Drop Link12016-04-28 20:00:05.080NULL
202Greenside2016-04-28 20:00:05.080Offline02016-04-28 20:00:05.080NULL
203Greenside2016-04-28 20:00:05.080Total122016-04-28 20:00:05.0801
204Greenside2016-04-28 20:00:05.080Up To Date112016-04-28 20:00:05.080NULL
221mafube2016-04-28 20:00:04.100Drop Link02016-04-28 20:00:04.100NULL
222mafube2016-04-28 20:00:04.100Offline12016-04-28 20:00:04.100NULL
223mafube2016-04-28 20:00:04.100Total202016-04-28 20:00:04.1001
224mafube2016-04-28 20:00:04.100Up To Date192016-04-28 20:00:04.100NULL
217Goedehoop South2016-04-28 20:00:01.947Drop Link02016-04-28 20:00:01.947NULL
218Goedehoop South2016-04-28 20:00:01.947Offline212016-04-28 20:00:01.947NULL
219Goedehoop South2016-04-28 20:00:01.947Total212016-04-28 20:00:01.9471
220Goedehoop South2016-04-28 20:00:01.947Up To Date02016-04-28 20:00:01.947NULL
209Goedehoop North2016-04-28 20:00:01.057Drop Link12016-04-28 20:00:01.057NULL
210Goedehoop North2016-04-28 20:00:01.057Offline62016-04-28 20:00:01.057NULL
211Goedehoop North2016-04-28 20:00:01.057Total212016-04-28 20:00:01.0571
212Goedehoop North2016-04-28 20:00:01.057Up To Date142016-04-28 20:00:01.057NULL
205zibulo2016-04-28 20:00:00.653Drop Link12016-04-28 20:00:00.653NULL
206zibulo2016-04-28 20:00:00.653Offline42016-04-28 20:00:00.653NULL
207zibulo2016-04-28 20:00:00.653Total222016-04-28 20:00:00.6531
208zibulo2016-04-28 20:00:00.653Up To Date172016-04-28 20:00:00.653NULL
193zibulo2016-04-28 14:07:39.490Drop Link02016-04-28 14:07:39.490NULL
194zibulo2016-04-28 14:07:39.490Offline02016-04-28 14:07:39.490NULL
195zibulo2016-04-28 14:07:39.490Total62016-04-28 14:07:39.4901
196zibulo2016-04-28 14:07:39.490Up To Date62016-04-28 14:07:39.490NULL
181kriel2016-04-27 21:00:01.147Drop Link02016-04-27 21:00:01.147NULL
182kriel2016-04-27 21:00:01.147Offline22016-04-27 21:00:01.147NULL
183kriel2016-04-27 21:00:01.147Total262016-04-27 21:00:01.1471
184kriel2016-04-27 21:00:01.147Up To Date242016-04-27 21:00:01.147NULL
185RLT2016-04-27 21:00:01.120Drop Link12016-04-27 21:00:01.120NULL
186RLT2016-04-27 21:00:01.120Offline02016-04-27 21:00:01.120NULL
187RLT2016-04-27 21:00:01.120Total82016-04-27 21:00:01.1201
188RLT2016-04-27 21:00:01.120Up To Date72016-04-27 21:00:01.120NULL
197landau2016-04-27 21:00:00.573Drop Link02016-04-27 21:00:00.573NULL
198landau2016-04-27 21:00:00.573Offline02016-04-27 21:00:00.573NULL
199landau2016-04-27 21:00:00.573Total32016-04-27 21:00:00.5731
200landau2016-04-27 21:00:00.573Up To Date32016-04-27 21:00:00.573NULL
189Klein kopje2016-04-27 21:00:00.260Drop Link02016-04-27 21:00:00.260NULL
190Klein kopje2016-04-27 21:00:00.260Offline12016-04-27 21:00:00.260NULL
191Klein kopje2016-04-27 21:00:00.260Total32016-04-27 21:00:00.2601
192Klein kopje2016-04-27 21:00:00.260Up To Date22016-04-27 21:00:00.260NULL
173New Denmark2016-04-27 20:30:00.770Drop Link02016-04-27 20:30:00.770NULL
174New Denmark2016-04-27 20:30:00.770Offline152016-04-27 20:30:00.770NULL
175New Denmark2016-04-27 20:30:00.770Total482016-04-27 20:30:00.7701
176New Denmark2016-04-27 20:30:00.770Up To Date332016-04-27 20:30:00.770NULL
177New Vaal2016-04-27 20:30:00.523Drop Link12016-04-27 20:30:00.523NULL
178New Vaal2016-04-27 20:30:00.523Offline32016-04-27 20:30:00.523NULL
179New Vaal2016-04-27 20:30:00.523Total152016-04-27 20:30:00.5231
180New Vaal2016-04-27 20:30:00.523Up To Date112016-04-27 20:30:00.523NULL
161Isibonelo2016-04-27 20:30:00.273Drop Link02016-04-27 20:30:00.273NULL
162Isibonelo2016-04-27 20:30:00.273Offline02016-04-27 20:30:00.273NULL
163Isibonelo2016-04-27 20:30:00.273Total92016-04-27 20:30:00.2731
164Isibonelo2016-04-27 20:30:00.273Up To Date92016-04-27 20:30:00.273NULL
157mafube2016-04-27 20:00:12.243Drop Link02016-04-27 20:00:12.243NULL
158mafube2016-04-27 20:00:12.243Offline12016-04-27 20:00:12.243NULL
159mafube2016-04-27 20:00:12.243Total202016-04-27 20:00:12.2431
160mafube2016-04-27 20:00:12.243Up To Date192016-04-27 20:00:12.243NULL
153Greenside2016-04-27 20:00:03.200Drop Link12016-04-27 20:00:03.200NULL
154Greenside2016-04-27 20:00:03.200Offline02016-04-27 20:00:03.200NULL
155Greenside2016-04-27 20:00:03.200Total122016-04-27 20:00:03.2001
156Greenside2016-04-27 20:00:03.200Up To Date112016-04-27 20:00:03.200NULL
149zibulo2016-04-27 20:00:02.680Drop Link12016-04-27 20:00:02.680NULL
150zibulo2016-04-27 20:00:02.680Offline42016-04-27 20:00:02.680NULL
151zibulo2016-04-27 20:00:02.680Total222016-04-27 20:00:02.6801
152zibulo2016-04-27 20:00:02.680Up To Date172016-04-27 20:00:02.680NULL
165Goedehoop South2016-04-27 20:00:01.690Drop Link02016-04-27 20:00:01.690NULL
166Goedehoop South2016-04-27 20:00:01.690Offline212016-04-27 20:00:01.690NULL
167Goedehoop South2016-04-27 20:00:01.690Total212016-04-27 20:00:01.6901
168Goedehoop South2016-04-27 20:00:01.690Up To Date02016-04-27 20:00:01.690NULL
169Goedehoop North2016-04-27 20:00:00.947Drop Link12016-04-27 20:00:00.947NULL
170Goedehoop North2016-04-27 20:00:00.947Offline62016-04-27 20:00:00.947NULL
171Goedehoop North2016-04-27 20:00:00.947Total212016-04-27 20:00:00.9471
172Goedehoop North2016-04-27 20:00:00.947Up To Date142016-04-27 20:00:00.947NULL
145RLT2016-04-26 21:00:01.257Drop Link12016-04-26 21:00:01.257NULL
146RLT2016-04-26 21:00:01.257Offline02016-04-26 21:00:01.257NULL
147RLT2016-04-26 21:00:01.257Total82016-04-26 21:00:01.2571
148RLT2016-04-26 21:00:01.257Up To Date72016-04-26 21:00:01.257NULL
141kriel2016-04-26 21:00:01.127Drop Link02016-04-26 21:00:01.127NULL
142kriel2016-04-26 21:00:01.127Offline22016-04-26 21:00:01.127NULL
143kriel2016-04-26 21:00:01.127Total262016-04-26 21:00:01.1271
144kriel2016-04-26 21:00:01.127Up To Date242016-04-26 21:00:01.127NULL
137Klein kopje2016-04-26 21:00:00.507Drop Link02016-04-26 21:00:00.507NULL
138Klein kopje2016-04-26 21:00:00.507Offline12016-04-26 21:00:00.507NULL
139Klein kopje2016-04-26 21:00:00.507Total32016-04-26 21:00:00.5071
140Klein kopje2016-04-26 21:00:00.507Up To Date22016-04-26 21:00:00.507NULL
125Isibonelo2016-04-26 20:30:01.307Drop Link02016-04-26 20:30:01.307NULL
126Isibonelo2016-04-26 20:30:01.307Offline02016-04-26 20:30:01.307NULL
127Isibonelo2016-04-26 20:30:01.307Total92016-04-26 20:30:01.3071
128Isibonelo2016-04-26 20:30:01.307Up To Date92016-04-26 20:30:01.307NULL
133New Denmark2016-04-26 20:30:00.647Drop Link02016-04-26 20:30:00.647NULL
134New Denmark2016-04-26 20:30:00.647Offline152016-04-26 20:30:00.647NULL
135New Denmark2016-04-26 20:30:00.647Total482016-04-26 20:30:00.6471
136New Denmark2016-04-26 20:30:00.647Up To Date332016-04-26 20:30:00.647NULL
129New Vaal2016-04-26 20:30:00.543Drop Link12016-04-26 20:30:00.543NULL
130New Vaal2016-04-26 20:30:00.543Offline32016-04-26 20:30:00.543NULL
131New Vaal2016-04-26 20:30:00.543Total152016-04-26 20:30:00.5431
132New Vaal2016-04-26 20:30:00.543Up To Date112016-04-26 20:30:00.543NULL
117mafube2016-04-26 20:00:04.620Drop Link02016-04-26 20:00:04.620NULL
118mafube2016-04-26 20:00:04.620Offline12016-04-26 20:00:04.620NULL
119mafube2016-04-26 20:00:04.620Total202016-04-26 20:00:04.6201
120mafube2016-04-26 20:00:04.620Up To Date192016-04-26 20:00:04.620NULL
105Greenside2016-04-26 20:00:03.530Drop Link12016-04-26 20:00:03.530NULL
106Greenside2016-04-26 20:00:03.530Offline02016-04-26 20:00:03.530NULL
107Greenside2016-04-26 20:00:03.530Total122016-04-26 20:00:03.5301
108Greenside2016-04-26 20:00:03.530Up To Date112016-04-26 20:00:03.530NULL
121Goedehoop South2016-04-26 20:00:01.760Drop Link02016-04-26 20:00:01.760NULL
122Goedehoop South2016-04-26 20:00:01.760Offline212016-04-26 20:00:01.760NULL
123Goedehoop South2016-04-26 20:00:01.760Total212016-04-26 20:00:01.7601
124Goedehoop South2016-04-26 20:00:01.760Up To Date02016-04-26 20:00:01.760NULL
109Goedehoop North2016-04-26 20:00:01.127Drop Link12016-04-26 20:00:01.127NULL
110Goedehoop North2016-04-26 20:00:01.127Offline62016-04-26 20:00:01.127NULL
111Goedehoop North2016-04-26 20:00:01.127Total212016-04-26 20:00:01.1271
112Goedehoop North2016-04-26 20:00:01.127Up To Date142016-04-26 20:00:01.127NULL
113zibulo2016-04-26 20:00:00.767Drop Link12016-04-26 20:00:00.767NULL
114zibulo2016-04-26 20:00:00.767Offline42016-04-26 20:00:00.767NULL
115zibulo2016-04-26 20:00:00.767Total222016-04-26 20:00:00.7671
116zibulo2016-04-26 20:00:00.767Up To Date172016-04-26 20:00:00.767NULL
97kriel2016-04-25 21:00:01.150Drop Link12016-04-25 21:00:01.150NULL
98kriel2016-04-25 21:00:01.150Offline12016-04-25 21:00:01.150NULL
99kriel2016-04-25 21:00:01.150Total262016-04-25 21:00:01.1501
100kriel2016-04-25 21:00:01.150Up To Date242016-04-25 21:00:01.150NULL
93Klein kopje2016-04-25 21:00:01.047Drop Link02016-04-25 21:00:01.047NULL
94Klein kopje2016-04-25 21:00:01.047Offline12016-04-25 21:00:01.047NULL
95Klein kopje2016-04-25 21:00:01.047Total32016-04-25 21:00:01.0471
96Klein kopje2016-04-25 21:00:01.047Up To Date22016-04-25 21:00:01.047NULL
101RLT2016-04-25 21:00:00.970Drop Link12016-04-25 21:00:00.970NULL
102RLT2016-04-25 21:00:00.970Offline02016-04-25 21:00:00.970NULL
103RLT2016-04-25 21:00:00.970Total82016-04-25 21:00:00.9701
104RLT2016-04-25 21:00:00.970Up To Date72016-04-25 21:00:00.970NULL
85New Denmark2016-04-25 20:30:01.013Drop Link02016-04-25 20:30:01.013NULL
86New Denmark2016-04-25 20:30:01.013Offline152016-04-25 20:30:01.013NULL
87New Denmark2016-04-25 20:30:01.013Total482016-04-25 20:30:01.0131
88New Denmark2016-04-25 20:30:01.013Up To Date332016-04-25 20:30:01.013NULL
89New Vaal2016-04-25 20:30:00.867Drop Link12016-04-25 20:30:00.867NULL
90New Vaal2016-04-25 20:30:00.867Offline32016-04-25 20:30:00.867NULL
91New Vaal2016-04-25 20:30:00.867Total152016-04-25 20:30:00.8671
92New Vaal2016-04-25 20:30:00.867Up To Date112016-04-25 20:30:00.867NULL
73mafube2016-04-25 20:00:03.290Drop Link02016-04-25 20:00:03.290NULL
74mafube2016-04-25 20:00:03.290Offline12016-04-25 20:00:03.290NULL
75mafube2016-04-25 20:00:03.290Total202016-04-25 20:00:03.2901
76mafube2016-04-25 20:00:03.290Up To Date192016-04-25 20:00:03.290NULL
80Goedehoop South2016-04-25 20:00:01.277Drop Link02016-04-25 20:00:01.277NULL
81Goedehoop South2016-04-25 20:00:01.277Offline212016-04-25 20:00:01.277NULL
82Goedehoop South2016-04-25 20:00:01.277Total212016-04-25 20:00:01.2771
84Goedehoop South2016-04-25 20:00:01.277Up To Date02016-04-25 20:00:01.277NULL
66Goedehoop North2016-04-25 20:00:01.080Drop Link12016-04-25 20:00:01.080NULL
68Goedehoop North2016-04-25 20:00:01.080Offline62016-04-25 20:00:01.080NULL
70Goedehoop North2016-04-25 20:00:01.080Total212016-04-25 20:00:01.0801
72Goedehoop North2016-04-25 20:00:01.080Up To Date142016-04-25 20:00:01.080NULL
65Greenside2016-04-25 20:00:00.840Drop Link02016-04-25 20:00:00.840NULL
71Greenside2016-04-25 20:00:00.840Up To Date122016-04-25 20:00:00.840NULL
69Greenside2016-04-25 20:00:00.840Total202016-04-25 20:00:00.8401
67Greenside2016-04-25 20:00:00.840Offline82016-04-25 20:00:00.840NULL
83zibulo2016-04-25 20:00:00.797Up To Date172016-04-25 20:00:00.797NULL
77zibulo2016-04-25 20:00:00.797Drop Link12016-04-25 20:00:00.797NULL
78zibulo2016-04-25 20:00:00.797Offline42016-04-25 20:00:00.797NULL
79zibulo2016-04-25 20:00:00.797Total222016-04-25 20:00:00.7971
61RLT2016-04-25 14:24:37.443Drop Link12016-04-25 14:24:37.443NULL
62RLT2016-04-25 14:24:37.443Offline02016-04-25 14:24:37.443NULL
63RLT2016-04-25 14:24:37.443Total82016-04-25 14:24:37.4431
64RLT2016-04-25 14:24:37.443Up To Date72016-04-25 14:24:37.443NULL
57mafube2016-04-25 13:58:03.643Drop Link02016-04-25 13:58:03.643NULL
58mafube2016-04-25 13:58:03.643Offline12016-04-25 13:58:03.643NULL
59mafube2016-04-25 13:58:03.643Total202016-04-25 13:58:03.6431
60mafube2016-04-25 13:58:03.643Up To Date192016-04-25 13:58:03.643NULL
53zibulo2016-04-25 13:14:04.027Drop Link12016-04-25 13:14:04.027NULL
54zibulo2016-04-25 13:14:04.027Offline42016-04-25 13:14:04.027NULL
55zibulo2016-04-25 13:14:04.027Total222016-04-25 13:14:04.0271
56zibulo2016-04-25 13:14:04.027Up To Date172016-04-25 13:14:04.027NULL
33Isibonelo2016-04-25 11:49:14.777Drop Link02016-04-25 11:49:14.777NULL
34Isibonelo2016-04-25 11:49:14.777Offline02016-04-25 11:49:14.777NULL
35Isibonelo2016-04-25 11:49:14.777Total92016-04-25 11:49:14.7771
36Isibonelo2016-04-25 11:49:14.777Up To Date92016-04-25 11:49:14.777NULL
37Klein kopje2016-04-24 21:00:01.000Drop Link02016-04-24 21:00:01.000NULL
38Klein kopje2016-04-24 21:00:01.000Offline12016-04-24 21:00:01.000NULL
39Klein kopje2016-04-24 21:00:01.000Total32016-04-24 21:00:01.0001
40Klein kopje2016-04-24 21:00:01.000Up To Date22016-04-24 21:00:01.000NULL
41kriel2016-04-24 21:00:00.637Drop Link12016-04-24 21:00:00.637NULL
42kriel2016-04-24 21:00:00.637Offline12016-04-24 21:00:00.637NULL
43kriel2016-04-24 21:00:00.637Total262016-04-24 21:00:00.6371
44kriel2016-04-24 21:00:00.637Up To Date242016-04-24 21:00:00.637NULL
29Isibonelo2016-04-24 20:30:00.780Drop Link02016-04-24 20:30:00.780NULL
30Isibonelo2016-04-24 20:30:00.780Offline02016-04-24 20:30:00.780NULL
31Isibonelo2016-04-24 20:30:00.780Total92016-04-24 20:30:00.7801
32Isibonelo2016-04-24 20:30:00.780Up To Date92016-04-24 20:30:00.780NULL
49New Denmark2016-04-24 20:30:00.323Drop Link02016-04-24 20:30:00.323NULL
50New Denmark2016-04-24 20:30:00.323Offline152016-04-24 20:30:00.323NULL
51New Denmark2016-04-24 20:30:00.323Total482016-04-24 20:30:00.3231
52New Denmark2016-04-24 20:30:00.323Up To Date332016-04-24 20:30:00.323NULL
25Greenside2016-04-24 20:00:02.713Drop Link02016-04-24 20:00:02.713NULL
26Greenside2016-04-24 20:00:02.713Offline82016-04-24 20:00:02.713NULL
27Greenside2016-04-24 20:00:02.713Total202016-04-24 20:00:02.7131
28Greenside2016-04-24 20:00:02.713Up To Date122016-04-24 20:00:02.713NULL
21Goedehoop South2016-04-24 20:00:01.757Drop Link02016-04-24 20:00:01.757NULL
22Goedehoop South2016-04-24 20:00:01.757Offline212016-04-24 20:00:01.757NULL
23Goedehoop South2016-04-24 20:00:01.757Total212016-04-24 20:00:01.7571
24Goedehoop South2016-04-24 20:00:01.757Up To Date02016-04-24 20:00:01.757NULL
17Goedehoop North2016-04-24 20:00:01.143Drop Link12016-04-24 20:00:01.143NULL
18Goedehoop North2016-04-24 20:00:01.143Offline62016-04-24 20:00:01.143NULL
19Goedehoop North2016-04-24 20:00:01.143Total212016-04-24 20:00:01.1431
20Goedehoop North2016-04-24 20:00:01.143Up To Date142016-04-24 20:00:01.143NULL
45New Vaal2016-04-23 20:30:00.777Drop Link12016-04-23 20:30:00.777NULL
46New Vaal2016-04-23 20:30:00.777Offline32016-04-23 20:30:00.777NULL
47New Vaal2016-04-23 20:30:00.777Total152016-04-23 20:30:00.7771
48New Vaal2016-04-23 20:30:00.777Up To Date112016-04-23 20:30:00.777NULL
13New vaal2016-04-21 10:18:19.873Drop Link12016-04-21 10:18:19.873NULL
14New vaal2016-04-21 10:18:19.873Offline32016-04-21 10:18:19.873NULL
15New vaal2016-04-21 10:18:19.873Total152016-04-21 10:18:19.8731
16New vaal2016-04-21 10:18:19.873Up To Date112016-04-21 10:18:19.873NULL
9Goedhoop north2016-04-21 10:12:53.867Drop Link12016-04-21 10:12:53.867NULL
10Goedhoop north2016-04-21 10:12:53.867Offline62016-04-21 10:12:53.867NULL
11Goedhoop north2016-04-21 10:12:53.867Total212016-04-21 10:12:53.8671
12Goedhoop north2016-04-21 10:12:53.867Up To Date142016-04-21 10:12:53.867NULL
5RLT2016-04-15 10:03:44.803Drop Link12016-04-15 10:03:44.803NULL
6RLT2016-04-15 10:03:44.803Offline62016-04-15 10:03:44.803NULL
7RLT2016-04-15 10:03:44.803Total212016-04-15 10:03:44.8031
8RLT2016-04-15 10:03:44.803Up To Date142016-04-15 10:03:44.803NULL
1Goedehoop North2016-04-14 06:25:11.693Drop Link12016-04-14 06:25:11.693NULL
2Goedehoop North2016-04-14 06:25:11.693Offline62016-04-14 06:25:11.693NULL
3Goedehoop North2016-04-14 06:25:11.693Total212016-04-14 06:25:11.6931
4Goedehoop North2016-04-14 06:25:11.693Up To Date142016-04-14 06:25:11.693NULL
June 1, 2016 at 6:43 am
I am not sure if you will be able to read it.example below
IDSite CaptureDate SEPStatusNoOfClients CreatedOn IsAtEnd
873landau 2016-05-26 21:00:01.370Drop Link0 2016-05-26 21:00:01.370NULL
June 1, 2016 at 6:54 am
Your script generates an error.
Text data should be delimited with single quotes, columns should be delimited with commas. Each row should be delimited with ( and ), and you will require a comma at the end of every row except the last one.
Like this:
(797, 'Isibonelo', '2016-05-19 20:30:01.900', 'Drop Link', 0, '2016-05-19 20:30:01.900', NULL),
(797, 'Isibonelo', '2016-05-19 20:30:01.900', 'Drop Link', 0, '2016-05-19 20:30:01.900', NULL) -- last row
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 1, 2016 at 6:57 am
YearDateMonthDateSEPStatusIsAtEndNoOfClients
2016.04Apr-2016Drop LinkNULL 34
2016.04Apr-2016OfflineNULL 368
2016.04Apr-2016Up To DateNULL 931
2016.04Apr-2016Total 1 1333
2016.05May-2016Drop LinkNULL 43
2016.05May-2016OfflineNULL 404
2016.05May-2016Up To DateNULL 1186
2016.05May-2016Total 1 1633
Above are the results from the query that i was using which is returning wrong results.
June 1, 2016 at 7:52 am
This is a corrected script for some sample data.
It doesn't fix any logic, just fixed the sample data script and changed formulas for the dates to shorter versions.
CREATE TABLE [dbo].[PNS_Sect_6_SiteSEPStatusSnapshot](
[ID] [int] NOT NULL,
[Site] [nvarchar](100) NULL,
[CaptureDate] [datetime] NULL,
[SEPStatus] [varchar](100) NULL,
[NoOfClients] [int] NULL,
[CreatedOn] [datetime] NULL,
[IsAtEnd] [bit] NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
--------------------------------------------
Insert into [PNS_Sect_6_SiteSEPStatusSnapshot](
ID,SITE,CaptureDate,SepStatus,NoOfclients,CreatedOn,IsAtEnd)
Values
(873, 'landau', '2016-05-26 21:00:01.370', 'Drop Link', 0, '2016-05-26 21:00:01.370',NULL),
(874, 'landau', '2016-06-26 21:00:01.370', 'Offline', 0, '2016-05-26 21:00:01.370',NULL),
(875, 'landau', '2016-07-26 21:00:01.370', 'Total ', 3, '2016-05-26 21:00:01.370',1 ),
(876, 'landau', '2016-08-26 21:00:01.370', 'Up To Date', 3, '2016-05-26 21:00:01.370',NULL),
(865, 'kriel' , '2016-09-26 21:00:01.350', 'Drop Link', 0, '2016-05-26 21:00:01.350',NULL),
(866, 'kriel' , '2016-10-26 21:00:01.350', 'Offline', 0, '2016-05-26 21:00:01.350',NULL);
DECLARE @DateVar datetime = '20160527'
SELECT LEFT(CONVERT(NVARCHAR, a.CaptureDate, 102), 7) AS YearDate
, STUFF( LEFT( a.CaptureDate, 11), 4, 4, '-') AS MonthDate
, a.SEPStatus
, a.IsAtEnd
, SUM(a.NoOfClients) AS NoOfClients
FROM [PNS_Sect_6_SiteSEPStatusSnapshot] AS a
WHERE CaptureDate BETWEEN DATEADD( MONTH, DATEDIFF( MONTH, 0, @DateVar) - 5, 0)
AND DATEADD( MONTH, DATEDIFF( MONTH, 0, @DateVar) + 1, 0)
GROUP BY LEFT(CONVERT(NVARCHAR, a.CaptureDate, 102), 7)
, STUFF( LEFT( a.CaptureDate, 11), 4, 4, '-')
, a.SEPStatus
, a.IsAtEnd
ORDER BY YearDate
, a.IsAtEnd
, a.SEPStatus;
June 1, 2016 at 8:01 am
I sorted some of data out to work with.
INSERT INTO [dbo].[PNS_Sect_6_SiteSEPStatusSnapshot](ID,Site,CaptureDate,SEPStatus,NoOfClients,CreatedOn,IsAtEnd)
Values(
(873,'landau','2016-05-26 21:00:01.370','Drop Link',0,'2016-05-26 21:00:01.370',NULL),
(874,'landau','2016-05-26 21:00:01.370','Offline',0,'2016-05-26 21:00:01.370',NULL),
(875,'landau','2016-05-26 21:00:01.370','Total',3,'2016-05-26 21:00:01.370',1),
(876,'landau','2016-05-26 21:00:01.370','Up To Date',3,'2016-05-26 21:00:01.370',NULL),
(865,'kriel','2016-05-26 21:00:01.350','Drop Link',0,'2016-05-26 21:00:01.350',NULL),
(866,'kriel','2016-05-26 21:00:01.350','Offline',0,'2016-05-26 21:00:01.350',NULL),
(867,'kriel','2016-05-26 21:00:01.350','Total',16,'2016-05-26 21:00:01.350'1),
(868,'kriel','2016-05-26 21:00:01.350','Up To Date',16,'2016-05-26 21:00:01.350',NULL),
(869,'RLT','2016-05-26 21:00:01.200','Drop Link',1,'2016-05-26 21:00:01.200',NULL),
(870,'RLT','2016-05-26 21:00:01.200','Offline',0,'2016-05-26 21:00:01.200',NULL),
(871,'RLT','2016-05-26 21:00:01.200','Total',8,'2016-05-26 21:00:01.200',1),
(872,'RLT','2016-05-26 21:00:01.200','Up To Date',7,'2016-05-26 21:00:01.200',NULL),
(857,'Klein kopje','2016-05-26 21:00:00.783','Drop Link',0,'2016-05-26 21:00:00.783',NULL),
(858,'Klein kopje','2016-05-26 21:00:00.783','Drop Link',0,'2016-05-26 21:00:00.783',NULL),
(859,'Klein kopje','2016-05-26 21:00:00.783','Offline',0,'2016-05-26 21:00:00.783',NULL),
(860,'Klein kopje','2016-05-26 21:00:00.783','Offline',0,'2016-05-26 21:00:00.783',NULL),
(861,'Klein kopje','2016-05-26 21:00:00.783','Total',3,'2016-05-26 21:00:00.783',1),
(862,'Klein kopje','2016-05-26 21:00:00.783','Total',13,'2016-05-26 21:00:00.783'1),
(863,'Klein kopje','2016-05-26 21:00:00.783','Up To Date',3, '2016-05-26 21:00:00.783',NULL),
(864,'Klein kopje','2016-05-26 21:00:00.783','Up To Date',13,'2016-05-26 21:00:00.783',NULL),
(845,'Isibonelo','2016-05-26 20:30:01.470','Drop Link',0,'2016-05-26 20:30:01.470',NULL),
(846,'Isibonelo','2016-05-26 20:30:01.470','Offline',0,'2016-05-26 20:30:01.470',NULL),
(847,'Isibonelo','2016-05-26 20:30:01.470','Total',8,'2016-05-26 20:30:01.470',1),
(848,'Isibonelo','2016-05-26 20:30:01.470','Up To Date',8,'2016-05-26 20:30:01.470',NULL),
(853,'New Vaal','2016-05-26 20:30:01.203','Drop Link',NULL,'2016-05-26 20:30:01.203',NULL),
(854,'New Vaal','2016-05-26 20:30:01.203','Offline',NULL,'2016-05-26 20:30:01.203',NULL),
(855,'New Vaal','2016-05-26 20:30:01.203','Total',0,'2016-05-26 20:30:01.203',1),
(856,'New Vaal','2016-05-26 20:30:01.203','Up To Date',NULL,'2016-05-26 20:30:01.203',NULL),
(849,'New Denmark','2016-05-26 20:30:00.880','Drop Link',0,'2016-05-26 20:30:00.880',NULL),
(850,'New Denmark','2016-05-26 20:30:00.880','Offline',1,'2016-05-26 20:30:00.880',NULL),
(851,'New Denmark','2016-05-26 20:30:00.880','Total',4,'2016-05-26 20:30:00.880',1),
(852,'New Denmark','2016-05-26 20:30:00.880','Up To Date',3,'2016-05-26 20:30:00.880',NULL),
(817,'kriel','2016-05-19 21:00:01.673','Drop Link',0,'2016-05-19 21:00:01.673',NULL),
(818,'kriel','2016-05-19 21:00:01.673','Offline',0,'2016-05-19 21:00:01.673',NULL),
(819,'kriel','2016-05-19 21:00:01.673','Total',16,'2016-05-19 21:00:01.673',1),
(820,'kriel','2016-05-19 21:00:01.673','Up To Date',16,'2016-05-19 21:00:01.673',NULL),
(809,'RLT','2016-05-19 21:00:01.080','Drop Link',1,'2016-05-19 21:00:01.080',NULL),
(810,'RLT','2016-05-19 21:00:01.080','Offline',0,'2016-05-19 21:00:01.080',NULL),
(811,'RLT','2016-05-19 21:00:01.080','Total',8,'2016-05-19 21:00:01.080',1),
(812,'RLT','2016-05-19 21:00:01.080','Up To Date',7,'2016-05-19 21:00:01.080',NULL),
(821,'landau','2016-05-19 21:00:00.710','Drop Link',0,'2016-05-19 21:00:00.710',NULL),
(822,'landau','2016-05-19 21:00:00.710','Offline',0,'2016-05-19 21:00:00.710',NULL),
(823,'landau','2016-05-19 21:00:00.710','Total',3,'2016-05-19 21:00:00.710',1),
(824,'landau','2016-05-19 21:00:00.710','Up To Date',3,'2016-05-19 21:00:00.710',NULL)
(813,'Klein kopje','2016-05-19 21:00:00.600','Drop Link',0,'2016-05-19 21:00:00.600',NULL),
(814,'Klein kopje','2016-05-19 21:00:00.600','Offline',0,'2016-05-19 21:00:00.600',NULL),
(815,'Klein kopje','2016-05-19 21:00:00.600','Total',13,'2016-05-19 21:00:00.600',1),
(816,'Klein kopje','2016-05-19 21:00:00.600','Up To Date',13,'2016-05-19 21:00:00.600',NULL)
(797,'Isibonelo','2016-05-19 20:30:01.900','Drop Link',0,'2016-05-19 20:30:01.900',NULL),
(798,'Isibonelo','2016-05-19 20:30:01.900','Offline',0,'2016-05-19 20:30:01.900',NULL),
(799,'Isibonelo','2016-05-19 20:30:01.900','Total',8,'2016-05-19 20:30:01.900',1),
(800,'Isibonelo','2016-05-19 20:30:01.900','Up To Date',8,'2016-05-19 20:30:01.900',NULL)
June 1, 2016 at 8:10 am
Thanks Luiz its returning same information as before.
I have a sql agent job that feeds information about clients computers into a table xxxx once a week.I have a report that runs monthend pulling information from table xxxx .I have a query that must run within a report showing (sum) number of clients that were supported that month and previous month.I want each machine to be counted once even though the job runs once a week x4.
My problem is each machine is counted more than once therefore i end up with thousands on supported clients on my report which is not true
June 1, 2016 at 8:19 am
tmmutsetse (6/1/2016)
Thanks Luiz its returning same information as before.I have a sql agent job that feeds information about clients computers into a table xxxx once a week.I have a report that runs monthend pulling information from table xxxx .I have a query that must run within a report showing (sum) number of clients that were supported that month and previous month.I want each machine to be counted once even though the job runs once a week x4.
My problem is each machine is counted more than once therefore i end up with thousands on supported clients on my report which is not true
If you reread Luiz's post, you'll find this:
It doesn't fix any logic, just fixed the sample data script and changed formulas for the dates to shorter versions.
There really is no need to say the same thing multiple times; we're bright people here.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 1, 2016 at 2:51 pm
It is hard to understand what is it your table represents. For each 'Site', first two rows look like daily count of events 'Drop link' and 'Offline'. Bottom two rows look like some totals dependent on 'Drop link' and 'Offline'. I see that Total = [Up to Date] - (Offline + [Drop Link]). You are dealing with tabulated report, not with a table in database and SQL sense. Since your data-set is not a table, it is difficult to apply SQL tools.
However, if you write query like this:
SELECT
[Site], CaptureDate, [Year] = year(CaptureDate), [Month] = Month(CaptureDate)
, CntIDs = COUNT(ID), MInID = MIN(ID), MaxID = MAX(ID)
, [Drop Link] = SUM (CASE SEPStatus WHEN 'Drop Link' THEN (NoOfClients) ELSE 0 END)
, [Offline] = SUM (CASE SEPStatus WHEN 'Offline' THEN (NoOfClients) ELSE 0 END)
, [Up to Date] = SUM (CASE SEPStatus WHEN 'Up To Date' THEN (NoOfClients) ELSE 0 END)
, Total = SUM (CASE SEPStatus WHEN 'Total' THEN (NoOfClients) ELSE 0 END)
FROM [PNS_Sect_6_SiteSEPStatusSnapshot]
GROUP BY [Site], CaptureDate
ORDER BY Site, CaptureDate
; , the result will look like this (maybe it is helpful for understanding what is going on):
Site CaptureDate Year Month CntIDs MInID MaxID Drop Link Offline Up to Date Total
------------- ----------------------- ----- ----- ------ ----- ----- --------- ------- ----------- -----
Isibonelo 2016-05-19 20:30:01.900 2016 5 4 797 800 0 0 8 8
Isibonelo 2016-05-26 20:30:01.470 2016 5 4 845 848 0 0 8 8
Klein kopje 2016-05-19 21:00:00.600 2016 5 4 813 816 0 0 13 13
Klein kopje 2016-05-26 21:00:00.783 2016 5 8 857 864 0 0 16 16
kriel 2016-05-19 21:00:01.673 2016 5 4 817 820 0 0 16 16
kriel 2016-05-26 21:00:01.350 2016 5 4 865 868 0 0 16 16
landau 2016-05-19 21:00:00.710 2016 5 4 821 824 0 0 3 3
landau 2016-05-26 21:00:01.370 2016 5 4 873 876 0 0 3 3
New Denmark 2016-05-26 20:30:00.880 2016 5 4 849 852 0 1 3 4
New Vaal 2016-05-26 20:30:01.203 2016 5 4 853 856 0 0 0 0
RLT 2016-05-19 21:00:01.080 2016 5 4 809 812 1 0 7 8
RLT 2016-05-26 21:00:01.200 2016 5 4 869 872 1 0 7 8
(12 row(s) affected)
It would be good to explain meanings of 'Drop Link', 'Offline', 'Up to Date', 'Total', then somebody would be able to help.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply