Pages

Komunikasi dalam Proyek

Kita bisa dalam posisi apa saja. Maka kita harus bisa mengkomunikasikan kondisi proyek saat ini.

Report Builder 3.0 crashes with Problem Event Name: CLR20r3

Today, i want to used Report Builder 3.0 to create or modified report on server SSRS.
Actually, the application was crashed and give me Pop Up windows with Problem Event Name: CLR20r3
Problem signature:  Problem Event Name: CLR20r3
Problem Signature 01: msreportbuilder.exe
 I try to search the solution on net and found this link from social.msdn.microsoft.com.
The solution is delete user configuration on path
C:\Users\<<user>>\AppData\Local\Microsoft\Report Builder\<<version>>
You can delete <<version>> folder.
It's worked for me.

SSRS Error: Cannot read the next data row for the dataset

An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the dataset [DataSet Name]. (rsErrorReadingNextDataRow) For more information about this error navigate to the report server on the local server machine, or enable remote errors.
Hari ini mengalami kendala error tersebut diatas dalam penerapan SSRS (SQL Server Reporting Service). Setelah mencari dari berbagai sumber di internet, permasalahan ini muncul karena ada parameter yang akan digunakan oleh report tersebut namun menggunakan tipe data yang bukan peruntukannya. Contoh ada parameter A seharusnya menggunakan tipe data Date/Time, namun menggunakan tipe data Text.

WhatsApp Messenger, Lifetime License

Today, i get update from WhatsApp that the service not only update on every year but extended to Lifetime.

Get report for Last Logon Time with Active Directory

I want to get this report because, sometime we must know that pc always use local user or their domain user. So, if i can grab this information from Active Directory, i can give it to user and tell them to use their domain user. User complain to us that they cannot access folder sharing on server because they only use their local user.
I search on internet and i found this from netwrix.com
  1. Open Powershell ISE.
  2. Create a new script with the following code (Define "domain" and "export-csv" fields):
    $Domain = "na.local"
    $InactiveFor = 0
    $Time = (Get-Date).Adddays(-($InactiveFor))
    Get-ADUser -Filter {LastLogonTimeStamp -lt $Time -and enabled -eq $true} -Properties LastLogonTimeStamp |
    select-object Name,@{Name="Stamp";
    Expression={[DateTime]::FromFileTime($_.lastLogonTimestamp).ToString('yyyy-MM-dd_hh:mm:ss')}} | export-csv C:\temp\lastlogon.csv –notypeinformation
  3. Run the script.
  4. Open a file produced by the script in MS Excel.

Google ganti logo

Hari ini, saya baru 'ngeh' (istilah bahasa Jawa untuk kata 'Sadar') mengenai perubahan logo Google, yang lebih 'fresh'. Perubahan ini diharapkan membawa semangat baru, tidak hanya hari ini, tetapi juga masa depan.

Sumber: Google Blog
"We think we’ve taken the best of Google (simple, uncluttered, colorful, friendly), and recast it not just for the Google of today, but for the Google of the future."

Google - New Logo

Filosopi Matematika #2

Kita pasti pernah mengetahui rumus matematika, seperti berikut
  1. (+) * (+) = (+)
  2. (-) * (+) atau (+) * (-) = (-)
  3. (-) * (-) = (+)

Ternyata rumus tersebut memiliki makna dalam kehidupan, sepert:
  1. (+) * (+) = (+)
    Maknanya, mengatakan yang BENAR terhadap sesuatu yang BENAR adalah tindakan yang BENAR
  2. (-) * (+) atau (+) * (-) = (-)
    Maknanya, mengatakan BENAR atas sesuatu yang SALAH atau sebaliknya mengatakan SALAH terhadap sesuatu yang BENAR adalah suatu tindakan yang SALAH.
  3. (-) * (-) = (+)
    Maknanya, mengatakan SALAH terhadap sesuatu yang SALAH adalah tindakan yang BENAR.
Semoga kita dapat mengambil hikmahnya atas rumus matematika tersebut.

Sumber: "ExceLEARN" Bulletin ExecuTrain of Jakarta | Edisi 3 Tahun IX | Jul-Sep 2014

How to Detect Who Added a User to Domain Admins Group

We know that Active Directory is one of important part on Company system, For Company that do not have any specific staff to manage this server, they will assign all of staff to do job. This will make susceptible to security breach. So we need to know the activity of this server like "Who Added a User to Domain Admins Group". I get some tips form Netwrix and Social Technet on Microsoft how to do it.
  1. Configure Audit Policy Settings by running GPMC.msc → Edit “Default Domain Policy” → Computer Configuration → Policies → Windows Settings → Security Settings → Local Policies → Audit Policy → Audit account management → Define → Success.
  2. Configure object-level Active Directory auditing settings by opening ADSI Edit → Connect to “Default naming context”→ Click “OK” → Right-click DomainDNS object with the name of your domain → Properties → Security (Tab) → Advanced (Button) → Auditing (Tab) → Add Principal “Everyone” → Type “Success” → Applies to “This object and Descendant objects” → Permissions: → Select all check boxes except the following: “Full Control”, “List Contents”, “Read all properties”, “Read permissions” → Click “OK”.
  3. Enlarge security event log capacity by running GPMC.msc → Edit “Default Domain Policy” → Computer Configuration → Policies → Windows Settings → Security Settings → Event Log → Define:
    • Maximum security log size to 1gb
    • Retention method for security log to “Overwrite events as needed”.
  4. Run “gpupdate /force” command.
  5. Run eventvwr.msc and filter security log for event id 4728 to detect when users are added to security-enabled global groups. The group name in our case is “Domain Admins”.
Source: www.netwrix.com | Tutorial on You Tube (Link).
Source: social.technet.microsoft.com by Santosh Bhandarkar