Logs Structure

204.2.1.6 Media Library Logs

Operations performed in the Media Library for specific assets are stored in the operations tab. Additionally, other -more general- logs are following described:

Searches

The SQL query executed for every search is recorded (per station) into the following file:
[Drive]:\Users\[USERNAME]\AppData\Local\Etere\Log\user.001\mam.etrc_forms.001.[PCNAME].Asset.log

mam.etrc_forms.001.michaelw7.Asset.log
12/03/2015 17:55:44.847 3572517.12 0000 ASSET SEARCH Try to execute bSearchClick function
12/03/2015 17:55:44.848 3572517.12 0000 ASSET SEARCH Executing bSearchClick function
12/03/2015 17:55:44.889 3572517.13 0000 SQL ___ +------------------------------
12/03/2015 17:55:44.889 3572517.13 0000 SQL 001 | if object_id('tempdb..#AssetSearch_MICHAELW7_162') is not null drop table #AssetSearch_MICHAELW7_162
12/03/2015 17:55:44.889 3572517.13 0000 SQL ___ |
12/03/2015 17:55:44.889 3572517.13 0000 SQL --> | Start Query
12/03/2015 17:55:44.889 3572517.13 0000 -------- BEGIN TRANSACTION ---------------
12/03/2015 17:55:44.890 3572517.13 0000 -------- COMMIT TRANSACTION ---------------
12/03/2015 17:55:44.890 3572517.13 0000 *********************************************
12/03/2015 17:55:44.890 3572517.13 0000 SQL --> | End Query
12/03/2015 17:55:44.890 3572517.13 0000 SQL ___ +------------------------------
12/03/2015 17:55:44.890 3572517.13 0000 SQL ___ +------------------------------
12/03/2015 17:55:44.890 3572517.13 0000 SQL 001 | declare @tUser table (idSerie int) insert into @tUser select distinct id_serie from fusers with (nolock) where ( cod_User in (1,2,3) ) if object_id('tempdb..#AssetSearch_MICHAELW7_162') is not null drop table #AssetSearch_MICHAELW7_162 create table #AssetSearch_MICHAELW7_162 (AssetID int, AssetCode nvarchar(32), SerieID int, AssetType nvarchar(4), Episode int, numOrd int, AInstallation int) insert #AssetSearch_MICHAELW7_162 Select ID_Filmati, Cod_Progra, Id_Serie, Newtype, Puntata, ROW_NUMBER() OVER(ORDER BY F.Cod_Progra ) AS RecNum , Installation from ( Select distinct F.ID_Filmati, F.Cod_Progra, F.Id_Serie, F.Newtype, F.Puntata ,F.Installation from dbo.Filmati F with (nolock) left join @tUser tU on f.id_serie=tU.idserie where hidden=0 and (F.newtype not in (select cod_type from tipologieusers with (nolock) where cod_user=1)) and (tU.idserie is null) and (isnull(F.Data_Scad,400000) > 42073) and (isnull(F.Data_Inizio_Validita,1) < 42074) and (substring(F.Enableddays, datepart(dw,42073),1) = '1') and ( F.installation in (701,0) ) and (F.newtype not in ('NZFD','NZST')) ) F select count(*) num from #AssetSearch_MICHAELW7_162
12/03/2015 17:55:44.890 3572517.13 0000 SQL ___ |
12/03/2015 17:55:44.890 3572517.13 0000 SQL --> | Start Query
12/03/2015 17:55:44.910 3572517.14 0000 SQL --> | End Query
12/03/2015 17:55:44.910 3572517.14 0000 SQL ___ +------------------------------
12/03/2015 17:55:44.912 3572517.14 0000 SQL ___ +------------------------------
12/03/2015 17:55:44.912 3572517.14 0000 SQL 001 | select F.id_filmati, F.cod_progra, F.descrizio, F.newtype, F.puntata, dbo._fn_hmsf(F.durata,'P') Durata, F.DATA_PROD, F.NOTE_COMM, F.NOTE_AMM, S.PERC_AUTOP, F.DESCRIZIO_1, F.DESCRIZIO_2, F.PARENT_RATE, F.PRODUZIONE, F.TRAMA, F.DATA_ARRIVO, F.DATA_SCAD, F.DATA_INIZIO_VALIDITA, F.DATA_DIGIT, F.ASPECT,F.ID_ASPECTRATIOCONV, F.ID_SERIE, substring(F.NOTE_A, 1, 1000) NOTE_A, substring(F.NOTE_B, 1, 1000) NOTE_B, substring(F.NOTE_C, 1, 1000) NOTE_C, F.PROD_INDIPENDENTE, F.AUDIO, F.LIVE_ID, F.NONTRASMISSIBILE, dbo.fs_GetMetafileIcons(F.id_filmati,0)+dbo.GetAssetTapeIcons(F.id_filmati) iconname, Scaduto=CASE WHEN F.Data_Scad >= (42073) THEN '' WHEN F.Data_Scad is null THEN '' ELSE '1' END ,VirtualAsset=CASE WHEN F.virtual=1 then '1' ELSE '' END, ClosedCapt=CASE WHEN F.Flag_non_udenti=1 then '1' ELSE '' END, livechn=CASE WHEN F.live_id is null then '' ELSE '1' END, F.Id_VirtualDocument, Readonly=CASE WHEN F.readonly=1 then '1' ELSE '' END, dbo.GetAspectDesc2(F.aspect) aspectDesc, F.id_responsabile Responsabile, Ag.Cod_conto Agency, F.parent_rate PRate, Ac.icon AspectConv, '' Artists, dbo.ass_Icon(F.ID_Filmati) TypeIcon, dbo.ass_Color(F.ID_Filmati) AssetColor, 0 NCodSupp, null codSupp, null TitleSupp, null TapeLocation, '' Genres, INST.Icon InstIcon, INST.Description IDescription, '' ConsumerAdvice, '' ETDescription, '' ETIcon, '' LastRun, CreationDate = case when F.CreationDate<5 then NULL else F.CreationDate end, NULL Cad_approval, Qualita = dbo.getQualityDescription(F.qualita), NULL Operatore, NULL Data_qualita, NULL Edl1,NULL Edl2,NULL Edl3,NULL Edl4,NULL Edl5,NULL Edl6,NULL Edl7,NULL Edl8,NULL Edl9,ExternalID = case when F.Installation = 701 then NULL else F.ExternalID end, thumbnail = case when S.image is null then 0 else 1 end , S.image, Season = case S.Season when 0 then NULL else S.Season end, S.Descrizio SDescrizio, NonAttivo=CASE WHEN F.Data_Inizio_Validita < (42074) THEN '' WHEN F.Data_Inizio_Validita is null THEN '' ELSE '1' END , 0 daprogrammare, F.Version , F.durata_pub , null nextuser , null nextdate , null nexthour ,'' Archived , null usersEnabled from (select assetid from #AssetSearch_MICHAELW7_162 with (nolock) where (numOrd> 0 and numOrd<=500) and Episode>=0) A join dbo.filmati F with (nolock) on F.ID_Filmati = A.AssetID left join dbo.fserie S with (nolock) on F.ID_serie = S.ID_serie left join Anagraf Ag on F.id_fornitore=Ag.id_anagraf left join AspectRatioConv Ac on F.id_aspectratioconv=Ac.id_aspectratioconv left join Installations INST on F.installation = INST.Installation or (F.installation = 0 and Local=1) order by F.Cod_Progra
12/03/2015 17:55:44.912 3572517.14 0000 SQL ___ |
12/03/2015 17:55:44.912 3572517.14 0000 SQL --> | Start Query
12/03/2015 17:55:45.103 3572517.19 0000 SQL --> | End Query
12/03/2015 17:55:45.103 3572517.19 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.103 3572517.19 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.103 3572517.19 0000 SQL 001 | Select dbo._fn_HHHHmsf(sum(F.durata), 'P') from (select assetid from #AssetSearch_MICHAELW7_162 with (nolock) where (numOrd> 0 and numOrd<=500) and Episode>=0) A join dbo.filmati F with (nolock) on F.ID_Filmati = A.AssetID left join dbo.fserie S with (nolock) on F.ID_serie = S.ID_serie left join Anagraf Ag on F.id_fornitore=Ag.id_anagraf left join AspectRatioConv Ac on F.id_aspectratioconv=Ac.id_aspectratioconv left join Installations INST on F.installation = INST.Installation or (F.installation = 0 and Local=1)
12/03/2015 17:55:45.103 3572517.19 0000 SQL ___ |
12/03/2015 17:55:45.103 3572517.19 0000 SQL --> | Start Query
12/03/2015 17:55:45.112 3572517.19 0000 SQL --> | End Query
12/03/2015 17:55:45.112 3572517.19 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.112 3572517.19 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.112 3572517.19 0000 SQL 001 | Select dbo._fn_HHHHmsf(sum(cast(F.durata as bigint)), 'P') from (select assetid from #AssetSearch_MICHAELW7_162 with (nolock) where Episode>=0) A join dbo.filmati F with (nolock) on F.ID_Filmati = A.AssetID left join dbo.fserie S with (nolock) on F.ID_serie = S.ID_serie left join Anagraf Ag on F.id_fornitore=Ag.id_anagraf left join AspectRatioConv Ac on F.id_aspectratioconv=Ac.id_aspectratioconv left join Installations INST on F.installation = INST.Installation or (F.installation = 0 and Local=1)
12/03/2015 17:55:45.112 3572517.19 0000 SQL ___ |
12/03/2015 17:55:45.112 3572517.19 0000 SQL --> | Start Query
12/03/2015 17:55:45.121 3572517.19 0000 SQL --> | End Query
12/03/2015 17:55:45.121 3572517.19 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.176 3572517.21 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.176 3572517.21 0000 SQL 001 | select AssetType,count(AssetID) num from #AssetSearch_MICHAELW7_162 with (nolock) where numOrd> 0 and numOrd<=500 group by AssetType
12/03/2015 17:55:45.176 3572517.21 0000 SQL ___ |
12/03/2015 17:55:45.176 3572517.21 0000 SQL --> | Start Query
12/03/2015 17:55:45.180 3572517.21 0000 SQL --> | End Query
12/03/2015 17:55:45.186 3572517.21 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.192 3572517.21 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.194 3572517.21 0000 SQL 001 | select isnull(cod_gen + ' ','') + isnull(descrizio,'') genere, FG.id_generi, count(FG.id_generi) num from (select assetid,serieid from #AssetSearch_MICHAELW7_162 with (nolock) where numOrd> 0 and numOrd<=500) F join dbo.fgeneri FG with (nolock) on F.SerieId=FG.id_serie join generi G with (nolock) on FG.id_generi=G.id_generi group by FG.id_generi,cod_gen,g.descrizio
12/03/2015 17:55:45.194 3572517.21 0000 SQL ___ |
12/03/2015 17:55:45.194 3572517.21 0000 SQL --> | Start Query
12/03/2015 17:55:45.203 3572517.21 0000 SQL --> | End Query
12/03/2015 17:55:45.203 3572517.21 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.203 3572517.21 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.203 3572517.21 0000 SQL 001 | select nomeArte = case when isnull(A.descrizio,'')='' then isnull(Nome+' ','')+isnull(cognome,'') else A.descrizio end, FA.id_artisti, FA.num from (select ID_artisti,count(ID_artisti) num from (select assetid,serieid from #AssetSearch_MICHAELW7_162 with (nolock) where numOrd> 0 and numOrd<=500) F join fartisti FA1 with (nolock) on (F.serieid=FA1.id_serie and FA1.id_filmati=0) group by ID_artisti union select ID_artisti,count(ID_artisti) num from (select assetid,serieid from #AssetSearch_MICHAELW7_162 with (nolock) where numOrd> 0 and numOrd<=500) F join fartisti FA2 with (nolock) on (F.AssetId=FA2.id_filmati) group by ID_artisti ) FA join artisti A with (nolock) on FA.id_artisti=A.id_artisti
12/03/2015 17:55:45.203 3572517.21 0000 SQL ___ |
12/03/2015 17:55:45.203 3572517.21 0000 SQL --> | Start Query
12/03/2015 17:55:45.211 3572517.21 0000 SQL --> | End Query
12/03/2015 17:55:45.211 3572517.21 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.212 3572517.21 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.212 3572517.21 0000 SQL 001 | select top 1 AInstallation from #AssetSearch_MICHAELW7_162 with (nolock)
12/03/2015 17:55:45.212 3572517.21 0000 SQL ___ |
12/03/2015 17:55:45.212 3572517.21 0000 SQL --> | Start Query
12/03/2015 17:55:45.213 3572517.21 0000 SQL --> | End Query
12/03/2015 17:55:45.213 3572517.21 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.213 3572517.21 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.213 3572517.21 0000 SQL 001 | select AInstallation,count(AssetID) num from #AssetSearch_MICHAELW7_162 with (nolock) where numOrd> 0 and numOrd<=500 group by AInstallation
12/03/2015 17:55:45.213 3572517.21 0000 SQL ___ |
12/03/2015 17:55:45.213 3572517.21 0000 SQL --> | Start Query
12/03/2015 17:55:45.216 3572517.21 0000 SQL --> | End Query
12/03/2015 17:55:45.216 3572517.21 0000 SQL ___ +------------------------------
12/03/2015 17:55:45.218 3572517.21 0000 ASSET SEARCH Executed bSearchClick function
If the asset export search returns more than 1000 assets, a warning message would be prompted. To proceed with the export search, click <Yes> to continue.

Asset_export_limit

Asset_export_limit